Your Microsoft Access file contains a Visual Basic procedure that uses an object, method, property, or event that is available in Access 2002 or later, but is not available in Access 2000. If you want to use an Access file in both Access 2000 and Access 2002 - 2003, compile and save the application in Access 2000 to ensure that the objects, methods, properties and events in your code are available in both versions.
An Access 2000 application runs more slowly after I save changes in Access 2002 or later.
When you open a Microsoft Access 2000 file for the first time in Access 2002 or later and save changes to a form, report, macro, or module, Access increments the version of the Visual Basic project. This prevents Access 2000 from loading the compiled version of the Visual Basic project. As a result, the application might run more slowly in Access 2000. To ensure optimal performance of an Access 2000 file that you will use in Access 2000 or later, compile and save the application in Access 2000.
After synchronizing an Access 2000 replica, I can't open it in Access 2000.
A member of the replica set was converted to Access 2002 - 2003 file format. Synchronizing an Access 2000 database with a database in Access 2002 or later converts the database.
In Access 2002 or later, a SQL statement that serves as the RecordSource property or the RowSource property for a form, report, or for a control such as a list box, combo box, unbound object frame, or Microsoft Office Web Component can contain a maximum of 32,750 characters. In Access 2000, this limit is approximately 2,000 characters.
A macro in an Access 2000 file that I am using in Access 2000 or later is not working as expected.
Some macro actions that are available in Access 2002 or later might not be available in Microsoft Access 2000. When you open the macro in Design view in Access 2000, a placeholder for any action that is not available appears in the Comments column with the following text:
Macro action from newer Access version: macro action
If you want to edit the macro in Access 2000, you can modify actions that come after any instance of placeholder text, and you can insert new actions after the last instance of placeholder text. However, if you modify actions that come before placeholder text, insert new actions before placeholder text, or modify the placeholder itself, the macro might not function as expected in Access 2002 or later.
I can't see some of the queries in an Access 2000 database when I open it in Access 2000.
In Microsoft Access 2000, queries based on ANSI-92 SQL query syntax are not visible in the Database window. If you want all of the queries in a Microsoft Access database to be available in Access 2000 or later, open the Access database in Access 2002 or later, click Options on the Tools menu, click the Tables/Queries tab, and under SQL Server Compatible Syntax (ANSI 92) clear the This database check box. After clearing the check box, you might have to modify some of your queries so they use Microsoft Jet SQL syntax.
In Access 2002 or later, when you open a data access page in Design view, Access makes a backup copy of the page and converts it so that it uses the latest version of the Microsoft Office Web Components. In Access 2000, you can no longer open the page in Design view, but you can open the backup copy of the page in Access 2000.
I can't save an Access 2000 file as an MDE or ADE in Access 2002 or later.
When you save a Microsoft Access file as an MDE or ADE file, Access 2002 or later adds information to the file. Because Access 2000 can't interpret this information, you can't save a file in Access 2000 file format as an MDE or ADE file while you are in Access 2002 or later.
To save a file in Access 2000 file format as an MDE or ADE file, do one of the following:
- Open the Access file in Access 2000, and then save it as an MDE or ADE file.
- In Access 2002 or later, convert the Access file to Access 2002 - 2003 file format, and then save it as an MDE or ADE file.