| | |
|
|
|
mdb file locked |
|---|
| message from =?Utf-8?B?UmVuYXRv?= on 1 Jun 2004 |
Hi all,
I've got a problem with a mdb file : everytime an user open it , another
user who wants to open that db can't do that; the error message is
'impossible to lock the file'; I thought it would be because the first
user opened the db in exclusive-mode, but it wasn't. I tried to
simply open the db using also the File menù + open + normal open
(not in exclusive mode) and at this point the file is locked : another
user is unable to open it.
I tried with two users , all of them work with an XP OS. Access version
is Access2000.
The db is on a server directory with the same permission to both users.
I'm worried about this could be a security bug of XP: pls tell me I'm wrong
and a solution to this problem!
Thanks in advance,
Renato
|
| =?Utf-8?B?Um9zY28=?= replied to =?Utf-8?B?UmVuYXRv?= on 1 Jun 2004 |
In addition to Ricks response. You might be better off splitting your database into a front end / back end. All the tables go in the back end, queries, forms, code in the front end. Each user gets a copy of the front end on their hard drive ( or share folder) that is linked to the common back end on the server.
This configuration will eliminate user locking conflicts. They would still need full read/write/modify rights for the folder the back end is stored in.
|
| Rick Brandt replied to =?Utf-8?B?UmVuYXRv?= on 1 Jun 2004 |
What permissions do the users have to the *folder* where the MDB resides?
They need file Create, Modify, Delete permissions in order for the LDB file
to be properly managed.
|
|
Archived message: mdb file locked (Microsoft Access Forms)
