I would appreciate some assistance please. Not an advanced user! Designing an access database. The intention is to allow more than one user to access and update at same time, but obviously restrict one user to update one record. For example. A.User amend record 6, B.User update record 32, both logged in at same time. Restrict example, do NOT permit two users to access same record at same time. I hope this all makes sense?
I did try "PROPERTIES/ADVANCED/EDITED RECORD set.
I'm tearing my hair out!!
Regards

You really don't need to worrry about this. Jet handles record locking by creating and managing an .ldb file each time you open an Access database.

The sharing issues usually revolve around lack of sufficient network priviledges for 1 or more users. In this situation, Jet may open a db in exclusive mode which would lock out other concurrent users. Because of the way .ldb files work, users MUST have sufficient permission to create/update/delete files in the directory holding the .mdb.