ACC: Cannot Convert Database with Same Name and Path

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

When you convert a Microsoft Access 1.x, 2.0, or 7.0 database to a Microsoft Access 97 database or you convert a Microsoft Access 1.x or 2.0 database to a Microsoft Access 7.0 database using the Convert command on the Tools menu, Database Utilities option, 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 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.

MORE INFORMATION

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.

REFERENCES