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 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.

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

For more information about database conversion, search the Help Index for "Converting databases," or ask the Microsoft Access 97 Office Assistant.

Keywords : kberrmsg kbusage CnvErrs
Version : 7.0 97
Platform : WINDOWS
Issue type : kbprb