Question on Multi-User Access

[ktchan741]

I have read the help file on multi-user access for MS Access but do not quite understand how to go about it.

If the database is residing in the network drive:

Can two different users access the database but different recordset at the same time?

If different users are accessing the databse at the same time, can each indiviual user save their record/data.

Is there anyway to ensure/prompt the user that a particular recordset are being access if another user try to edit the same recordset at the same time.

Can anyone share some advise. Thanks.

 

[Glohamar]

Alot of the questions youare asking have been answered in these forums. I would do a keyword search for multiuser and see what comes up. Also there is a FAQ for the record locking so that only one person can edit a single record at a time. Check faq702-3571

Two different users can access the same database, but has to be two differen records (see FAQ above), and they can save, edit, add and delete.

HTH
Dave