Several individual working in same table? from a form?

RCMetrics

Board Regular
Joined
Oct 28, 2005
Messages
95
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?
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,088
Members
412,310
Latest member
mark884
Top