Entering data in MS Access

Limit the database access to one person. Not recommended.

Use document management software that keeps track of versions. Recommended.

The easiest way is to open the database exclusively.

Open the Access Application (not a database)-

Click "File"- "Open" (or press CTRL+O)

Use the drop down box to the right of the OPEN button to select "Open exclusive"

This then means you are the only user who can edit the database for the duration of the session.

Alternatively, for a slightly more sophisticated solution-

Click "Tools" - "Options"

Click on the "Advanced" tab

Select from one of the three locking options on the right hand side of the form.

"No locks" only locks a record after it has been modified, not during editing.

"All records" locks the entire table where a field is being edited.

"Edited record" locks the record currently being edited, and releases after the user saves or navigates away.

This can also be set on a form level using the "Record Locks" property.