Open and Edit Records at ther same time.

K

Ken Sheridan

Yes. In a multi-user environment you should split the database into front
and back ends, the latter on the server and containing the tables, a copy of
the former on each workstation with the forms, queries, reports etc.

If two users are attempting to edit the same record simultaneously the
behaviour will depend on the locking strategy employed. If you use
optimistic locking (No Locks) which is the default setting, the record is
locked only when its saved. Concurrent users who experience a conflict will
be prompted as to what action they wish to take to resolve the conflict.

If you use pessimistic locking (Edited Record) then the record is locked
once a user begins to edit it and other users cannot edit it until the edited
record has been saved.
 
V

Van T. Dinh

Yes but users should not use the DatasheetView of the Table for direct data
entry. In properly-implemented database applications, users should use
Forms for data entry, not DatasheetView of the Table.

In a multi-user Access application, the application should be split into
Front-End (GUI) and Back-End (data). The Back-End (Table data only)
resideds on a shared directory so that the users can access the shared data.
The Front-End consists of other Access objects and each user should have a
copy of the Front-End on his/her desltop. Thus, in this case, each user use
a separate copy of the data entry Form, anyway.
 
Top