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

Response time when remote offices connect to central Access db

P: 2
We developed a db to support some data entry work and reporting. The work is done in US, Europe, & Asia. When we rolled out the db, it worked fine in the US, but Asia & Europe took an hour to open the db and 20 min to go through the data entry process, which should take 2-3 minutes.

When we approach our IT group for support, they advised...

"unfortunately Access is not a "tool" that lends itself to usage across the WAN. There is no "quick fix" to enabling the Access database you have created to work effectively globally."

Any thoughts on ways around this issue. Is it true that a central MS Access db cannot be accessed remotely ? What's the best way to allow remote locations to work in the db without delays ? Of course, it must be secure.

Appreciate any help.
Aug 8 '07 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
Here's a very good article on WANs and Access.

http://members.shaw.ca/AlbertKallal/Wan/Wans.html

Welcome to TheScripts!

Linq ;0)>
Aug 8 '07 #2

P: 2
Thank you for the article and warm welcome !



Here's a very good article on WANs and Access.

http://members.shaw.ca/AlbertKallal/Wan/Wans.html

Welcome to TheScripts!

Linq ;0)>
Aug 8 '07 #3

Post your reply

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