Access 2003 and 2000 Issue
Posted on 2006-06-08
I am creating a database to be used by multiple people. Of course, the Access version that this database will be used on isn't the same on all computers (How shocking!). I am developing it in Access 2003 (Access 2000 format) and ran into an issue about the references. I copied the references from a 2000 machine and have referenced those instead (Outlook 0 and Word 9). They have been placed on the same network drive as the database resides.
To see if it worked I started the database on my computer (running 2003) and then went to a co-workers computer running 2000. I started a copy of the front end (didn't want to run the same copy) and his wouldn't start while mine was running. He can run his if mine isn't running with no problem - a little slower than on my computer - but it starts up.
While he is running the database, if I try to run the other copy of the database, mine is very very very slow to start up (did I mention VERY) although it will eventually run.
I get no errors (like someone else is using the database and I can't open it) until I shut it down (before it starts). Then I am told it can't find one of the referenced files for the mdb file.
I can run both the original database and a copy of the database on my computer and both start up with no problems.
Please consider being my hero for the day and solving my problem! Thanks!