Access 97 Multi-user Problem

[Guest]

I have an access 97 database which I modified to attach to a SQL 2000
database. In some cases, only one user can open the database at a time.
Other users, however, can open it with no problem. The database is not maked
Exclusive and the mdw looks normal. Does anyone know why this is a problem
and what do I do to fix it?

There could be different versions of MDAC installed on the users pc's.
Could that be the problem? SQL Server is using 2.8. The NT user group has
full rights to the folder where the database resides.



Jim

 

[Joseph Meehan]

I have an access 97 database which I modified to attach to a SQL 2000
database. In some cases, only one user can open the database at a
time. Other users, however, can open it with no problem. The
database is not maked Exclusive and the mdw looks normal. Does anyone
know why this is a problem and what do I do to fix it?

There could be different versions of MDAC installed on the users pc's.
Could that be the problem? SQL Server is using 2.8. The NT user
group has full rights to the folder where the database resides.



Jim

Take a good look at the shortcut the problem user(s) are using. I am
guessing it has a switch set to open exclusively.

 

[Rick Brandt]

I have an access 97 database which I modified to attach to a SQL 2000
database. In some cases, only one user can open the database at a
time. Other users, however, can open it with no problem. The
database is not maked Exclusive and the mdw looks normal. Does anyone
know why this is a problem and what do I do to fix it?

There could be different versions of MDAC installed on the users pc's.
Could that be the problem? SQL Server is using 2.8. The NT user
group has full rights to the folder where the database resides.

In order for the locking file (ldb) to be properly managed for multiple
users all users must have the following permissions on the FOLDER where the
MDB resides.

File Create
File Edit
File Delete

If the first user to open the file does not have File Create permissions on
the folder then no LDB file is created and that is the same as opening the
file exclusively.