Several individual working in same table? from a form?

[RCMetrics]

Is it possible to get several individual working in the same table (from a form) without having them to access the same rows.."records"?

-There's up to 10 persons working in same Access Database
-They are working on thousands of requests


From a form, I would like:

Person 1 to access a record and avoid person 2 to 10 to access it while person 1 is in (or viewing it).

What should I do?

 

[Andrew Fergus]

Hi

Go into the form design screen, click Edit -> Select Form, click View -> Properties -> Data tab -> Record Locks -> set this property to 'Edited Record'.

This should prevent multiple users trying to edit the same record on the one form.

Also, have a look at this website for a couple more suggestions.

HTH, Andrew