Record Locking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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?
 
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

----- Chris wrote: ----

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?
 
Yes, I got what you mean. Do you have experiencing on what would happen when the same record opens by the second user?
 
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"

----- Chris wrote: ----

Yes, I got what you mean. Do you have experiencing on what would happen when the same record opens by the second user?
 
Back
Top