By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,281 Members | 1,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,281 IT Pros & Developers. It's quick & easy.

How do I setup a database for multiple users?

P: n/a
I have a database that I created that will be used by five seperate
people in my company. Everything else I have created in Access has
been for use by one person. I have never setup a database for a multi
user environment and need some help. Can somebody please explain what
steps are needed?

All help is greatly appreciated.

Sep 12 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Wed, 12 Sep 2007 13:09:22 -0000, lucky33 <ki*******@bellsouth.net>
wrote:

You need to split your database between tables and everything else.
Then put the tables db on a server, and in the everything else db you
create links to the tables in that db. Give each user that second db.

Newer versions of Access have a wizard to help with this process, but
it really is as simple as I just said.

-Tom.

>I have a database that I created that will be used by five seperate
people in my company. Everything else I have created in Access has
been for use by one person. I have never setup a database for a multi
user environment and need some help. Can somebody please explain what
steps are needed?

All help is greatly appreciated.
Sep 12 '07 #2

P: n/a

"lucky33" <ki*******@bellsouth.netwrote
I have a database that I created that will be used by five seperate
people in my company. Everything else I have created in Access has
been for use by one person. I have never setup a database for a multi
user environment and need some help. Can somebody please explain what
steps are needed?
In addition to Tom's suggestion, there are many other useful items of
information on performance and avoiding corruption at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm and in Jeff Conrad's "Access Junkie"
subsite at http://www.accessmvp.com.

Larry Linson
Microsoft Access MVP
Sep 12 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.