I have a database that is intended to be used by one user at a time. Occasionally another user may use it in which case they get an error message about saving. Is there a way to set a lock on it so that if a user is already in the database it simply won't let anyone else open it until they have finished? Kind of getting a message saying that it's available as Read-Only.
Any advice?
-Gina Grafilo
+ Reply to Thread
Results 1 to 3 of 3
Thread: Locking a Database
-
07-07-2009 09:42 PM #1
- Join Date
- Jul 2009
- Posts
- 3
Locking a Database
-
07-08-2009 06:23 AM #2
- Join Date
- Dec 1969
- Posts
- 80
How many programs access the database?
Dave
-
07-08-2009 08:03 AM #3
- Join Date
- Jul 2009
- Posts
- 3
How many programs or how many users? Currently have 2 users. I just don't want one user locking out the other. Is there a way to prevent the locking?
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts