Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2000 and Access 97 running the same 97 application

Status
Not open for further replies.

ronleclair

Programmer
Nov 16, 2001
2
US
I have an issue with A97 and A2K. I have an application that is shared to multiple users. It is a A97 application and up until now, all the users had A97. Slowly, some of the users are being upgraded to A2K. So, now we have users with A2K and A97 accessing the A97 database at the same time.

Here is the issue. If the A97 users are already in the database, the A2K users cannot access the database because it is already open. Solutions at that point would be to have the A97 users close and have the A2K users open first in order to 'convert' the database. This then allows all users to get in no problem. Even the A2K users can close the application and then open it no problem. (Unless they log off, thus resetting their session variables.)

Is there some way to allow the A2K users to open the application when A97 users are already in the application without having to make the A97 users close out first??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top