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

Moving data center - where should the Access databases be located, closer to the user

P: 1
My company is moving its data center to another location and keeping some of the business functions at its current location which will become a remote site (ie, one file server onsite). There will be a direct connection between the two locations.

We have many Access databases (2002) that pull information from different data sources and export them to different data sources for reporting purposes. These servers and data sources will be moving to the new data center. The question is, where should the Access database be located, closer to the applications or closer to the users?

Should we have the users go across the network to the Access database, or should we have the Access database closer to the user and have it make the calls across the network?
Jun 29 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,398
I would say never go across a network for Acceess databases. Access is more exposed than most apps to slow network connections. Make it as local as you can get it.
Jun 30 '12 #2

Post your reply

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