If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sharing a database
I created a database on a network drive that would allow three users to gain
access. However, only one user is able to get in the database at a time. If the database is occupied and another user tries to get in--they'll receive an message that says "Could not lock file." Not sure what I did when I set this thing up, but I could use a viable solution or suggestion |
#2
|
|||
|
|||
Check your settings in Tools Options Advanced, and look at your settings
for Default Open Mode and Default Record Locking. That is where your problem is, most likely, originating. Sharkbyte "Sapphyre" wrote: I created a database on a network drive that would allow three users to gain access. However, only one user is able to get in the database at a time. If the database is occupied and another user tries to get in--they'll receive an message that says "Could not lock file." Not sure what I did when I set this thing up, but I could use a viable solution or suggestion |
#3
|
|||
|
|||
The more common issue is the inability of the first user in to create the
LDB file. All users must have create and delete permissions on the folder containing the MDB file. -- Duane Hookom MS Access MVP "Sharkbyte" - wrote in message ... Check your settings in Tools Options Advanced, and look at your settings for Default Open Mode and Default Record Locking. That is where your problem is, most likely, originating. Sharkbyte "Sapphyre" wrote: I created a database on a network drive that would allow three users to gain access. However, only one user is able to get in the database at a time. If the database is occupied and another user tries to get in--they'll receive an message that says "Could not lock file." Not sure what I did when I set this thing up, but I could use a viable solution or suggestion |
#4
|
|||
|
|||
*blush*
Very true, Duane. I entirely skipped the first sentence, where he/she states this file is on a network drive. =) Sharkbyte "Duane Hookom" wrote: The more common issue is the inability of the first user in to create the LDB file. All users must have create and delete permissions on the folder containing the MDB file. -- Duane Hookom MS Access MVP "Sharkbyte" - wrote in message ... Check your settings in Tools Options Advanced, and look at your settings for Default Open Mode and Default Record Locking. That is where your problem is, most likely, originating. Sharkbyte "Sapphyre" wrote: I created a database on a network drive that would allow three users to gain access. However, only one user is able to get in the database at a time. If the database is occupied and another user tries to get in--they'll receive an message that says "Could not lock file." Not sure what I did when I set this thing up, but I could use a viable solution or suggestion |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HELP! CANNOT CONNECT TO SQL SERVER | Glint | General Discussion | 19 | May 9th, 2005 02:47 PM |
Sharing a Database file | Chris Chandler | General Discussion | 0 | August 12th, 2004 08:49 PM |
Please Help, The database is in an unexpected state; Microsoft Access can't open it. | Gary A. Hollenbeck | New Users | 2 | May 20th, 2004 05:42 PM |