First and foremost, the database needs to be split. There is a tool to do
this at Tools, Database Utilities, Database Splitter. It will put all the
tables in one mdb file called the Back End (BE) and the forms, reports,
queries, etc., in another mdb file called the Front End (FE).
Put the original database file out on a network folder where all users can
get to it. Do the splitting there. For this to work, all users need to have
the same drive mapping. For example if the BE is out on
P:\Databases\Database_BE.mdb, all users need to have the P drive mapped the
same way.
Ideally all user will have a copy of the FE on their PC. Failure to give
each user a copy can cause performance problems plus locking problems.
All users of the database must have at least read, write, and modify
privileges to the folder holding the database file. Not just the database
..mdb file, but the entire folder.
Open the database and go to Tools, Options, and Advanced Tab. Set the
Default Open mode to Shared and the Default Record Locking to Edited Record.
(While you are in the Options area, go over to the General tab and turn off
Compact on Close and Name AutoCorrect. Trust me on this.)
