Microsoft KB Archive/121472

= ACC: Error Converting Version 1.1 Database to 2.0, 95, 97 =

Article ID: 121472

Article Last Modified on 1/19/2007

-

APPLIES TO


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

-



This article was previously published under Q121472



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



SYMPTOMS
When you try to convert a Microsoft Access version 1.1 database to Microsoft Access 2.0, 7.0, or 97, and the database has a table with a field name that contains a backward apostrophe (`), you may receive the following error message:

In Microsoft Access 97:

"The Microsoft Jet database engine could not find the object ''. Make sure the object exists and that you spell its name and the path name correctly."

In Microsoft Access 2.0 and 7.0:

'' is not a valid filename



CAUSE
A backward apostrophe is allowed in table field names in Microsoft Access version 1.1, but is not allowed in Microsoft Access 2.0, 7.0 and 97.



RESOLUTION
Remove the backward apostrophe from the table in version 1.1 before you try to convert the database.



Steps to Reproduce Behavior
 In Microsoft Access version 1.1, create a new database. Name the database DB1.MDB.  Create the following new table called Table1:

     Table: Table1 --     Field Name: One` Data Type: Text

NOTE: The backward apostrophe is above the TAB key to the left of the number 1 key on most keyboards.)  Quit Microsoft Access 1.1. Start Microsoft Access 2.0, 7.0 or 97 and convert the Microsoft Access 1.1 database:

In Microsoft Access 7.0 or 97:

<ol style="list-style-type: lower-alpha;"> On the Tools menu, point to Database Utilities, and then click Convert Database.</li> Select the Db1.mdb database in the File Name box, and then click OK. Note that you receive the error.</li></ol>

In Microsoft Access 2.0:

<ol style="list-style-type: lower-alpha;"> On the File menu, click Convert Database.</li> Select the DB1.MDB database in the File Name box, and click OK. Note that you receive the error.</li></ol> </li></ol>

<div class="references_section">