Database setting for only 1 user at a time

[KEKeogh]

I'm using Access 2013.

What I need to do is get my one database to open with full rights when a person but if another user tries to open the database it only opens as read only.

Anyway to code this into the specific database?

Kathie

 

[smig]

Why ?
Access records locks will mostly enough.

 

[HiTechCoach]

I'm using Access 2013.

What I need to do is get my one database to open with full rights when a person but if another user tries to open the database it only opens as read only.

Anyway to code this into the specific database?

Kathie

Katie,

I have had to do something similar he past. I needed to "lock" the system when some procedures were being run.

I always do every database split. It just makes thing so much easier.

In the front end there is an option to "lock" the database. Now only that user gets full access. ALl other users become "read-only".

I control this by writing the user ID into a table in the back end. All the front end check this table to for the mode of the database.

I have used this method for over 30 years with accounting system with many diffent back ends.

If using a JET/ACE (mdb/acdb) back end:
You could also check the "locking" database (.ldb/.accdl)( file for the back end to see is there are any other connected front ends.