single user only

[qster]

Hello,
I wanted to find out if there is a way to set up Access 2000 like Excel so that when one user is in the database file and the second user acesses the file, the 2nd user should get a pop up box stating that User X has it opened and the file is read only.

I have set the setting for Exclusive and locked all records, but other users are still able to get in, but they do not know the tables are locked.

Thank you

 

[Craig0201]

Check for the existence of the ldb file? If it exists then someone already is in.

Craig

 

[qster]

I know of that option, however the users may not notice the .ldb file and go into the database without looking for it.

I had this database as a shared file with the db compacting on exit and it crashed each time when 3 or more users where in the db.

 

[ZmrAbdulla]

Hi,

Why don't you set the compacting to a fixed time than everytime close it. There was an FAQ to compact the DB on a fix time another on a fixed size.

Hope this helps

Zameer Abdulla

http://www.geocities.com/zameerabd/

 

[Craig0201]

Why can't you check for the file in code on your opening form?

Sub Form_Open
If Dir("LDBFilePathHere") = "" Then
MsgBox "App is already open, app will close"
Application.Quit
End If
End Sub

Craig

 

[qster]

Craig,

This code doesn't seem to work properly when I enter it.
So basically it seems that Access does not have a setting to inform a user(s) that another user is in the database.

Q