Unlocking an Access Database so multiple users can access it.

[JayBuck]

We have an access database that is set to record level locking - but only one
person at a time can access it. We need multiple user access at the same
time. How do we set this up? We are running Office Professional 2003, and
Office Professional 2007, and the database is set to run as 2000. Help??

 

[Daniel Pineault]

Have you split your db? If not, that is the first thing you must do. Spit
your db into a front-end and back-end (Tools -> Database Utilities ->
Database Splitter). Then set your back-end on a central server (or a network
connect everyone has access to) and give each user a copy of the front-end.
They each need their own copy, do not connect them all to 1 copy!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Tony Toews [MVP]]

We have an access database that is set to record level locking - but only one
person at a time can access it. We need multiple user access at the same
time. How do we set this up? We are running Office Professional 2003, and
Office Professional 2007, and the database is set to run as 2000. Help??

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
free Auto FE Updater utility at http://www.autofeupdater.com/ to make
the distribution of new FEs relatively painless.. The utility also
supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/