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

How can multi-users access a ms access 2007 database

P: 2
I have a MS access database 2007. I need to make it accessible to multi-users simultaneously so that all can print , mail ad update it while all the database copies must be updated.
Mar 3 '14 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,287
You split the database.
Be carefull here, although the wizard does a bang-up job of splitting, there are ways of optimizing the tables between the front and back ends, queries will generally stay on the front-end and so should all of your forms.

IMHO: Only a PROPERLY NORMALIZED database should be split; however, I've seen some very poorly designed databases split and they work quite well.

Here is a link to the basic information: http://office.microsoft.com/en-us/ac...010342026.aspx
Mar 3 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.