Access 2002 and Access 2003 Compatibility Issue

[crhodus]

I have an Access db that is going to be shared by two different users. One user has Access 2003 and the other has Access 2002. Will there be any problems using this setup if both the users are accessing the MDB file at the same time?

Thanks,
CR Junk

 

[FoFa]

I usually create the DB in Access 2000 format, and we have had no issues that comes to mind.

 

[gemma-the-husky]

no problems, only issue seems to be that a mde created in A2003 can't be read by A2002

 

[boblarson]

One other problem that could occur is if you use ADO or DAO code. If so, you should set the correct references and use the full qualifier when dimming those objects, because ADO is the default in A2002 and DAO is the default in A2003.

 

[crhodus]

This may be a dumb question, but how can I determine if the db was created in Access 2000 format?

Thanks,
CR Junk