Microsoft KB Archive/141615

= ACC: Cannot Convert Database with Same Name and Path =

Article ID: 141615

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q141615



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you convert a Microsoft Access 1.x, 2.0, or 7.0 database to a Microsoft Access 97 database (or when you convert a Microsoft Access 1.x or 2.0 database to a Microsoft Access 7.0 database) by using the Convert Database command on the Database Utilities option of the Tools menu, you can specify a destination database with the same path and file name as the source database. However, you may receive the following error message:

You can't convert a Microsoft Access database to the same name and location.



CAUSE
Microsoft Access 7.0 and 97 cannot convert a database if the source and destination databases have the same name and path even though you are prompted to verify that you want to replace the file.



RESOLUTION
Specify either a different name or a different path for the source and destination databases. If you want to use the same name, you must use a different path.



Steps to Reproduce Behavior

 * 1) Start Microsoft Access 7.0 or 97.
 * 2) On the Tools menu, click Database Utilities, and then click Convert Database.
 * 3) In the Database To Convert From dialog box, specify a valid Microsoft Access database, and then click OK.
 * 4) In the Convert Database Into dialog box, specify the same database name and path by double-clicking the database name, and then click OK.
 * 5) When you are prompted whether you want to replace the source database, click Yes. Note that you receive the error message mentioned in the "Symptoms" section.

