Dear jkjmwilliams:
You are in luck! Microsoft Access is multiuser right out of the box! You
will need to set up your application to use two files: a "front end"
database file and a "back end" database file (FE and BE). The BE mdb will
contain the tables with data, and it will reside on a shared folder on the
server. All users must have full read/write/edit permissions on this folder.
Each user will have their own copy of the FE mdb on their workstations.
These FE mdb files will link to the tables in the BE mdb. Access has a
wizard called the "Linked tables manager" to help you with this.
Some (ok.. a lot of...) useful links:
http://www.accessmvp.com/JConrad/accessjunkie/splitting.html
HTH
Fred Boer
