Is there a way to lock just one record?

[ripvanfish]

I would like to know if there is any way to lock just one record while a user is editing a record in a form. I know the "edited locks" option goes 2K in either direction, and that locks up a wide range of records in the database I am working with. I played around with some VBA code, but even the "lockedits" property of a recordset goes 2K in either direction. We tried "No Locks" but there were too many times where more than one user was trying to change fields in the same record, and one person lost all their data.

Any suggestions would be greatly appreciated!

 

[Guest_imported]

Hi,

If you are using Access 2000 you can use the Row Level Locking option to lock only the row being edited.