That's no problem. In fact two or more users can be inserting or editing
records in the same table simultaneously. If you use 'Edited Record' as the
locking strategy, which is the favoured strategy these days, only one user
can edit the same record at one time, that's the only real restriction.
For multi-user use you should first split the database into a 'front end'
and 'back end', the former containing the forms, reports queries etc, the
latter just the tables. The front end contains links to the tables in the
back end. The built in database splitter wizard will do this for you. The
back end file should be placed in a shared location on the network, and each
user's local machine should have a separate copy of the front end installed
on it. You can refresh the links to the back end if its moved to a location
other than the one in which it was created by means of the built in Linked
Table Manager.
Ken Sheridan
Stafford, England
