Software

Ask something
Discussion Locked

Access97 database can't open in 2000

0 helpful
7 replies

by chris k

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
We have a database built in Ac97 that is a standard here. A user has installed Ac2000. When he opens the db, he gets message - db you are trying to open or convert is currently in use, or you don't have permission to open it exclusively. We don't want to convert the db and we want the user to be able to use 2000. Is there a way to get around this with assigning permissions to this one user and keep the database in 97?? Or is there any other solutions I'm missing? Thanks!

7 replies

by otl

In Access 2000 Tools -> Options -> Advanced -> Default open mode changed it to Shared. With no locks and only record level locking enabled. Also under tables/queries Run permissions user's. Make sure he is in the same group as the other users.

by suzannei

I know we have run into this message with our unconverted databases. The impression I got is that the first time a user with O2K tries to open a 97 database, they need to have exclusive access (i.e. no else can be in it at the time), then choose whatever the alternative is to converting the database (Open or whatever). Access will do whatever it needs to let the user use the db, and from then on it should be fine. Not that the O2K user needs exclusive access, even though they are not converting the database.

This discussion is closed to new replies.