Access 2000 file format

[Guest]

Hi all

Although all users have Access 2002, my database now says (Access 2000 file
format) at the top of the database window when opened on any PC. Anyone know
what I can do to convert it back to 2002 format please?

Many thanks

 

[John Spencer]

By default the datafile are in Access 2000 file format. If you really want
to convert the file format then open the database in design view, go to
tools, Database Utilities, Convert Database and select the option to convert
to 2002 file format.
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.

 

[Guest]

Thanks a million

By default the datafile are in Access 2000 file format. If you really want
to convert the file format then open the database in design view, go to
tools, Database Utilities, Convert Database and select the option to convert
to 2002 file format.
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.

 

[Douglas J Steele]

Actually, that won't convert the databases she's already created.

As John correctly pointed out, you need to use Database Utilities | Convert
to change any existing databases.