Converting MS Access97 to MS Access 2000 or XP

[Bill Gilbert]

Does MS Access 2000 or MS Access XP provide for an easy
transition from MS Access 97. Do existing forms and code
have to be redesigned and rewritten? Does all table data
export easily from the 97 version? Is there an advantage
to upgrade or does it require major overhaul of existing
databases?

 

[Rick Brandt]

Does MS Access 2000 or MS Access XP provide for an easy
transition from MS Access 97.

Yes. Database Utilities - Convert Database to Current Version

The only caveat is making sure that the app will fully compile without errors in A97
before attempting the conversion.

Do existing forms and code
have to be redesigned and rewritten?
Nope.

Does all table data
export easily from the 97 version?
Yep.

Is there an advantage
to upgrade

Highly questionable in my opinion. Check the new features list and see if any of
them are compelling to you. If you're going to do it though, definitely go with 2002
(XP) and don't bother with 2000.

or does it require major overhaul of existing
databases?

The biggest change (for you) will be when you develop brand new databases. If you
code a lot and make extensive use of DAO you will either have to learn to use ADO
instead or remember to add the DAO library reference to every new file you create.
2000 and 20002 do not include a reference to DAO by default, but one can be added
easily.