Software

Ask something
Discussion Locked

Access 2000 vs. Access 2002

0 helpful
5 replies

by jgthompson1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have built a database in Access 2000 and I have added new computers to my network but Access 2000 is not available from my vendor. Can I use Access 2002 without corupting my database? If so can I run both software versions or will I need to use one exclusively?

5 replies

by donq

Haven't tried this but Microsoft says 2000 and 2002 use the same engines??? Open a 2002 .mdb file and "import" all Front-end queries, forms, reports, macros, modules, etc. Convert new 2002 file if necessary leaving original undisturbed. Lastly "link" new 2002 front-end to old 2000 Tables.

by janicew

I have switched between Access 2000 and 2002 on a database repeatedly with no corruption problems. Specifically, I have modified table designs, added queries, modified reports and created new reports all without incident. Modifications made on either platform work on the other. You'll notice when running 2002, that after the database name that Access 2000 format appears in paranthesis.

All literature on the topic also indicates that the engine is the same and there are not the compatibility issues of past version upgrades with Access.

This discussion is closed to new replies.