General discussion


Entering data in MS Access

By marie.hall ·
What would keep more than one person from entering data in a MSAccess database at the same time?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Some ideas

by BFilmFan In reply to Entering data in MS Acces ...

Limit the database access to one person. Not recommended.

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

Collapse -

by p.w.d.stone In reply to Entering data in MS Acces ...

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.

Collapse -

What is your goal?

by rreeder In reply to Entering data in MS Acces ...

Do you want to prevent this from happening? Or do you want to enable this as an option?

Related Discussions

Related Forums