Convert Access 97 to Access 2003

Just open it in the newer version an access will propose a conversion.

Nic;o)

But make sure before doing this that the database is "clean compiled".
Open some VBA code and select "Debug/Compile all modules"
Solve the errors first or the conversion can fail without a warning !

Nic;o)

Do you mean Access97 mdb (database)?

If you are using 2000, 2002, 2003
Opening the access97 db will give you an option to convert the db.

if you do the conversion, you will retain the acc97 mdb and will have a new mdb

if the 97 version was created with security in mind then you will need to use the mdw accociated with it, or give the admin account full permissions and use any security file

cheers

Don't forget to reference DAO 3.6 Object Library after you convert. Access 2000 up uses ADO as a base while Access 97 used DAO. So you'll need to reference DAO since you'll most likely have code using DAO in your program...

Andrew

Hi
If a 97 access file is opened and changed to be able to be read in 2000/2002/2003 and saved, can the file be read by opening it back in 97?
Cheers
          Marcus

no you will receive "unrecognised database format", unless you use the option save as prior version of access


cheers