Access97 to Access2003

[Gary D.]

I wish to upgrade to 2003 from 97 but cannot find conclusive
statements on the Microsoft web site that this is possible. It
mentions 2000 format, but not 97.

Can somebody please give me a definitive yes or no?

 

[Douglas J. Steele]

Actually, the default file format in Access 2003 (and Access 2002, for that
matter) is the Access 2000 format. This is done to allow greater usability:
users with any of the 3 versions can work with the same mdb file now.

You might be interested in the Microsoft Office Access 2003 Conversion
Toolkit, specifically designed to help analyze Access 97 databases for
upgrade and conversion to Access 2003. Check:
http://www.microsoft.com/office/ork/2003/tools/default.htm
http://www.microsoft.com/office/ork/2003/journ/accessconvert.htm

You might also want to read some of the advice Allen Browne has about
converting from Access 97 at
http://allenbrowne.com/ser-48.html

 

[Douglas J. Steele]

Should probably have added that there is also an Access 2002/2003 format
that's possible, but there are few issues that I'm aware of converting from
Access 2000 to Access 2002/2003 format.