Users on two different access platforms using the same database

[irishhelp]

We have a database developed in Access 97 and two users who use it in 97. We have a 3rd user who accesses the database using Access 2002. The database is set to shared. It appears as though the 97 users must be out of the database before the 2002 user can access. Even then, she receives conversion errors two or three times before getting in. She is then able to work. When I check the tables list in the 97 database, we had 40 conversion error tables.

Any ideas on sharing a database between 97 and 2002?

Thanks

irishhelp

 

[bclm]

Had to do the same thing. I am in XP and all my users are 97. Install the Access runtime on all pc's for which ever version you want (97 or XP). Then on desktop icon make shortcut mapping to the runtime first, then to the actual application. Hope this helps!