Speed up MS-Access Query Editing - Prevent Checking Database Connections

Is there an option in MS-Access to prevent it from checking the database connections when opening a query for edit.  I am working remotely over a VPN connection and it take 5-10 minutes or more to open a query in design view or when saving the query.  I am assuming that it is verifying the database connections - may be something else.  Any suggestions would be appreciated.  I am using MS-Access 2007 running MS-Access 2000 mode.
LVL 16
Jerry PaladinoAsked:
Who is Participating?
 
jmoss111Connect With a Mentor Commented:
I understand; keep a stripped down version locally for testing then there will be no long delay. When testing complete relink to VPN backend.
0
 
jmoss111Commented:
Keep a local stripped down copy for test purposes
0
 
Jerry PaladinoAuthor Commented:
First let me apologize for not putting all the information in my question that I should have.
My MS-Access db does not contain any data locally.  All the tables are linked to remote CSV and Excel files that exist on a network server in our corporate datacenter.  So each time I edit, I am guessing it is checking the connections over the VPN and that is what is causing the delay.
0
 
Jerry PaladinoAuthor Commented:
Thanks Jim...  I appreciate your help... Have a great weekend!  -  Jerry
0
 
jmoss111Commented:
Happy to help Jerry!

And you have one too.

Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.