We help IT Professionals succeed at work.

Convert Access 97 to Access 2003

pbelec
pbelec asked
on
2,215 Views
Last Modified: 2011-03-21
Is there a way to convert an Access 97 file to another version of Access. 2000, 2002, 2003.
Comment
Watch Question

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

Nic;o)

Commented:
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)
CERTIFIED EXPERT
Top Expert 2016

Commented:
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
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.