Record lock question

[NikoTheBowHunter]

how do i go about making the following happen?

while a user is working in a record, it locks it out preventing others from accessing it?



i.e., user enters a device number and hits the search button(in the form I've created), then the database/access locks the record out until user hits the update button or closes the record out. While the record is locked, no other users have access to it, should they try and access it they receive a pop up message stating user so-in-so is currently updating record.

can anyone help me out with this or is there a simple tutorial i can be pointed to. i have very little access experience and ever less coding experience. so trying to keep this as simple as possible.

thanks

[Bob Fitz]

I think you just need to set the DB's Record Locks property. See: https://support.office.com/en-gb/art...ad=GB&fromAR=1

[NikoTheBowHunter]

thanks, I wasn't sure if this would work seeing how i only have the one table. but so long as my update form locks only the one record out while the user is updating it, this should work. thanks for the help.

[HiTechCoach]

... seeing how i only have the one table.

Having only a single table is the root of many issues with a multi-user database. This is no better than an Excel file.

From my accounting background, I use avoid every editing a record. I only add records. I think in terms of transactions for most data. This also creates a built-in audit trail.