Access 2002 features that aren't available in Access 2000

Features that are new in Microsoft Access 2002 are available when you use a Microsoft Access 2000 file in Access 2002 file format, but aren't available when you use the same file in Access 2000. These features include the following:

• PivotTable view and PivotChart view.
• Ability to use queries in ANSI-92 query mode without using the ActiveX Data Objects (ADO) in a Microsoft Visual Basic procedure in an Access database.
• Ability to import and export XML.
• Speech and handwriting recognition.
• Multiple undo and redo.
• Binding of reports, list boxes, and combo boxes to ADO recordsets.
• Ability to specify the icon used in the title bar of forms and reports in a particular Access file.
• Adding, editing, or deleting records in an Access project without defining a primary key in the table.
• Support for user-defined functions, extended properties, indexed views, and named parameters in an Access project.
• Ability to choose encoding when outputting a database object to text or HTML.
• Increased limit of 32,750 characters for a SQL statement that serves as the RecordSource property or 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. In Access 2000, this limit is approximately 2000 characters.

In most cases, you can use an Access file that implements an Access 2002 feature in Access 2000 without any problems. However, if you open an Access 2000 file in Access 2002 and create a Visual Basic procedure that uses an object, function, property, method, or argument that is available only in Access 2002, you'll receive a compile error when you open the Access file in Access 2000.