Access 2002 or later features that aren't available in Access 2000
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:
a.. 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.).
b.. 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.).
c.. 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.).
d.. Speech and handwriting recognition.
e.. Multiple undo and redo.
f.. 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.).
g.. Ability to specify the icon used in the title bar of forms and
reports in a particular Access file.
h.. 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.
i.. 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.
j.. Ability to choose encoding when outputting a database object to
text or HTML.
k.. 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.
--
Dwayne W. Anderson
BS Information Technology
GMT - EST US
(e-mail address removed)
(e-mail address removed)
Toni said:
I created an access application in Access 2000 which was used company wide.
The Network Administrator has started to upgrade some users to Access 2003
(I also have Access 2003). When I make a change to the application (add a
new button to a form, create a new query, etc) the users who are still
running Access 2000 have trouble running the application. It does not show
any errors but when it opens up the main menu (which I created using the
Switchboard manager), nothing happens when they click on the buttons. If I
run the same application on my PC which is running Access 2003, I have no
problems.
