ACC2000: The Database Object Does Not Exist Error Message

• Microsoft Access 2000

SYMPTOMS

If you have a Microsoft Access project (.adp) on a computer that has a different code page setting than the server to which you are linking, and you use characters particular to the client's code page in the name of an object, you may experience the following behavior:

• You are not able to view the object in Design view.



• You see the following errors:




The object '<object name>' does not exist in the database.

-or-

ADO error: No item by the name of 'dbo.????' could be found in the current database '<Database Name>', given that @itemtype was input as '(null)'.

• You may see no errors with views; however, views may appear blank in Design view. You are allowed to view a database diagram in Design view.



• If you rename a table, view, or stored procedure using characters particular to the client computer's code page, the name may be changed to question marks, and you may see the following error:




The database object no longer exists.

• If you name a column in a table with characters from the client's code page, the column may not be displayed in datasheet view.

CAUSE

The code page setting for the keyboard on the server on which Microsoft SQL Server is running is different from the code page setting on the computer running the Microsoft Access project (.adp).

RESOLUTION

When you create or rename objects in an Access project (.adp), use a computer that has the same code page as the server.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Problem

1. Set up Microsoft SQL server on a computer running a U.S. English version of Windows NT, Windows 95, or Windows 98 (The U.S. English version defaults to the code page 1252 WIN LATIN I, which is also used by Western Europe).



2. Set up Microsoft Office 2000 on a computer running the Greek (or any language version that does not use code page 1252) version of Windows or Windows NT .



3. Open Access 2000.



4. On the File menu, click New.



5. In the New dialog box, on the General tab, click Project (Existing Database).



6. In the File New Database dialog box, save the new database project as TestCharacters.adp.



7. In the Data Link Properties dialog box, enter the name of the SQL Server, a valid user name and password, and the database that you want to use. Click OK.



8. In the new Access project, make a copy of any table and give the new table a name that uses Greek characters.



9. Try to view the new table in Design view.
   
   Note that you receive one of the errors listed in the "Symptoms" section of this article.

Additional query words: pra japanese chinese russian turkish arabic cyrillic slavic int'l international localization localisation globalization

Keywords : kbdta AccessCS
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug