| | |
|
|
|
Record Locking |
|---|
| message from =?Utf-8?B?Q2hyaXM=?= on 12 May 2004 |
I am new to MS Access. I have read a lot of books of Access but none of them mention deeply about record locking or table locking. I wonder will Access handles all lockings with mulit users.
|
| =?Utf-8?B?UGFuZ28=?= replied to =?Utf-8?B?Q2hyaXM=?= on 12 May 2004 |
Go to tools>options>advanced and see the available options. See that all users will need to have read and write permissions to the folder where the access database is located so as they can create the .ldb file. you can go in the access database itself and specify permissions.
Hope I helped
|
| =?Utf-8?B?Q2hyaXM=?= replied to =?Utf-8?B?UGFuZ28=?= on 12 May 2004 |
Thanks. Sorry that my enquiry is not clear. What I want to know is if in multi users environment, how does Access handle the same record called by 2+ different users?
|
| =?Utf-8?B?UGFuZ28=?= replied to =?Utf-8?B?Q2hyaXM=?= on 12 May 2004 |
If in the options you specify to lock the edited record, the record will be locked by the very first user who opens it.
If you specify no locks, then chances are that the last user to save info will overwrite when he is prompted to do so.
I hope you got the answer.
|
| =?Utf-8?B?Q2hyaXM=?= replied to =?Utf-8?B?UGFuZ28=?= on 12 May 2004 |
Yes, I got what you mean. Do you have experiencing on what would happen when the same record opens by the second user?
|
| =?Utf-8?B?UGFuZ28=?= replied to =?Utf-8?B?Q2hyaXM=?= on 12 May 2004 |
Yes I have. The second user, got a snapshop of the last time the record was saved. When trying to edit, status bar went like "records have been locked for editing".
|
| =?Utf-8?B?Q2hyaXM=?= replied to =?Utf-8?B?UGFuZ28=?= on 12 May 2004 |
Thanks. That means I don't have to use code to mange record locking?
|
|
Archived message: Record Locking (MS Access)
