Lock a record the moment it is accessed

[jazuraff]

SOLVED:Lock a record the moment it is accessed

Hello all!

I am a first time poster, however I have followed this forum for quite some time and appreciate the level of help provided by those who are versed in the access world! Here is my situation:

I am absolutely amazed that forums are not saturated with this question, I looked for some time now and haven't found a true solution to my problem.

I have 10 users accessing an access database at one time. All 10 are going to be using the same form to make edits to preloaded records. I need to find a way to check a record upon entering it to see whether it is locked and either tell the user it is or simply move on to a new record that isnt locked etc.

The big issue i foresee here is that the record changes are not reflected in the table untill you move on to the next record. Bottom line is i cant have 4 people working the same record only to find out only one of their work is going to be used. Here are my theories:

1. Create a yes/no field called record lock and have it checked as soon as the user enters the record. Upon leaving the record, uncheck it. I just dont know how to reflect the "lock" immidiately to other users

2. Requery the form everytime you move on to a new record and only who records that dont have a check record lock... Again, I just dont know how to make the lock appear in the table IMMIDIATELY upon entering the record.

Any help would be great! Thanks!

 

[jdraw]

Is your database split -- FE/BE?

This article may give you some insight into records and locking
http://msdn.microsoft.com/en-us/library/office/bb208487(v=office.12).aspx

 

[jazuraff]

The DB is not split, the greatest reason is there is some serious lag between linked tables within the provided network drive. I will read your link thanks!

 

[jdraw]

You may get some ideas from this list as well
http://www.fmsinc.com/microsoftaccess/performance.html

 

[jazuraff]

jdraw, Thanks for all the help. So i had a "Noob" fix to my problem, figured I would post it in case someone else was interested.

My solution is easily fixable by going into the tools/options then the advanced tab and clicking the edited record radio button. My problem initially was that my forms werent doing what i selected. Returning back from my blonde moment, I realized that you need to change that property for each form in the data properties for the form. It worked. It locked the records currently being edited by any number of users...

I also split my DB's to FE/BE and while it is a bit more laggy, the fact that all my data is centralized and the users can simply work on it from anywhere on their local machine is honestly worth it. thanks for the help!