How do you set up Access 2003 so mulitable users can access and work in the same data base?
B Brad Mar 14, 2008 #1 How do you set up Access 2003 so mulitable users can access and work in the same data base?
D DM Mar 14, 2008 #3 I use 02 SP3 at home but 03 at work and both configured the same if you know 02. tools_security
J John W. Vinson Mar 14, 2008 #4 How do you set up Access 2003 so mulitable users can access and work in the same data base? Click to expand... Short answer: it's multiuser out of the box. If the .mdb file is in a shared folder, two (or, theoretically, 255) users can open it and use it. Better answer: to prevent bloating, risk of corruption, and poor performance, use a "split" database. See http://www.granite.ab.ca/access/splitapp.htm for details.
How do you set up Access 2003 so mulitable users can access and work in the same data base? Click to expand... Short answer: it's multiuser out of the box. If the .mdb file is in a shared folder, two (or, theoretically, 255) users can open it and use it. Better answer: to prevent bloating, risk of corruption, and poor performance, use a "split" database. See http://www.granite.ab.ca/access/splitapp.htm for details.
