Show All

Hide All

Features that are new in Microsoft Access 2002 or later are available when you use 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.) in Access 2002 - 2003 file format, but aren't available when you use the same file in Access 2000. These features include the following:

• PivotTable view (PivotTable view: A view that summarizes and analyzes data in a datasheet or form. You can use different levels of detail or organize data by dragging the fields and items or by showing and hiding items in the drop-down lists for the fields.) and PivotChart view (PivotChart view: A view that shows a graphical analysis of data in a datasheet or form. You can see different levels of detail or specify the layout by dragging fields and items or by showing and hiding items in the drop-down lists for the fields.).
• Ability to use queries in ANSI-92 query mode (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.) without using the ActiveX Data Objects (ADO) (ActiveX Data Objects (ADO): A data access interface that communicates with OLE DB-compliant data sources to connect to, retrieve, manipulate, and update data.) in a Microsoft 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.) in an Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.).
• Ability to import and export XML (Extensible Markup Language (XML): A condensed form of Standard Generalized Markup Language (SGML) that enables developers to create customized tags that offer flexibility in organizing and presenting information.).
• Speech and handwriting recognition.
• Multiple undo and redo.
• Binding of reports, list boxes, and combo boxes to ADO recordsets (recordset: The collective name given to table-, dynaset-, and snapshot-type Recordset objects, which are sets of records that behave as objects.).
• 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 (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.) without defining a primary key (primary key: One or more fields (columns) whose values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.) in the table.
• Support for user-defined functions (function: A query that takes input parameters and returns a result like a stored procedure. Types: scalar (multistatement; returns one value), inline (one statement; an updateable table value), and table (multistatement; table value).), 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 (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.). In Access 2000, this limit is approximately 2000 characters.

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