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
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.)
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I have about ten users who need to access a single Access 2k3 database at the
> same time. Is this possible? if so, what needs to happen in order for it to
> Any help will be appriciated!