Your Microsoft Access file (Microsoft Access file: An Access database or Access project file. An Access database stores database objects and data in an .mdb file. A project file doesn't contain data and is used to connect to a Microsoft SQL Server database.) contains a Visual Basic procedure (procedure: A sequence of declarations and statements in a module that are executed as a unit. Procedures in Visual Basic include both Sub and Function procedures.) that uses an object, method (method: A procedure similar to a statement or function that operates on specific objects. For example, you can apply the Print method to the Debug object to transfer printed output to the Immediate window.), property (property: A named attribute of a control, a field, or an object that you set to define one of the object's characteristics (such as size, color, or screen location) or an aspect of its behavior (such as whether the object is hidden).), or event (event: An action recognized by an object, such as a mouse click or key press, for which you can define a response. An event can be caused by a user action or a Visual Basic statement, or it can be triggered by the system.) 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.

When you open a Microsoft Access 2000 file (Microsoft Access file: An Access database or Access project file. An Access database stores database objects and data in an .mdb file. A project file doesn't contain data and is used to connect to a Microsoft SQL Server database.) 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.

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 (list box: A control that provides a list of choices. A list box consists of a list and an optional label.), combo box (combo box: A control used on a form that provides the combined functionality of a list box and a text box. You can type a value, or you can click the control to display a list and then select an item from that list.), unbound object frame (unbound object frame: A control that you place on a form or report to contain an unbound object. An unbound object is an object, such as a picture, whose value isn't derived from data stored in a table.), or Microsoft Office Web Component (Microsoft Office Web Components: Interactive components, such as worksheets, charts, and PivotTable lists on Web pages that facilitate data analysis. To use these components, you must have a Microsoft Office license.) can contain a maximum of 32,750 characters. In Access 2000, this limit is approximately 2,000 characters.

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.

In Microsoft Access 2000, queries based on ANSI-92 SQL query syntax (ANSI SQL query mode: One of two types of SQL syntax: ANSI-89 SQL (also called Microsoft Jet SQL and ANSI SQL), which is the traditional Jet SQL syntax; and ANSI-92 SQL, which has new and different reserved words, syntax rules, and wildcard characters.) 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 (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.), Access makes a backup copy of the page and converts it so that it uses the latest version of the Microsoft Office Web Components (Microsoft Office Web Components: Interactive components, such as worksheets, charts, and PivotTable lists on Web pages that facilitate data analysis. To use these components, you must have a Microsoft Office license.). 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.

When you save a Microsoft Access file (Microsoft Access file: An Access database or Access project file. An Access database stores database objects and data in an .mdb file. A project file doesn't contain data and is used to connect to a Microsoft SQL Server database.) as an MDE (MDE file: Microsoft Access database (.mdb) file with all modules compiled and all editable source code removed.) or ADE (ADE file: A Microsoft Access project (.adp) file with all modules compiled and all editable source code removed.) 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.