Solved

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

Posted on 2009-04-04
5
265 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:Jerry Paladino
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:jmoss111
ID: 24070137
Keep a local stripped down copy for test purposes
0
 
LVL 16

Author Comment

by:Jerry Paladino
ID: 24070163
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
 
LVL 18

Accepted Solution

by:
jmoss111 earned 500 total points
ID: 24070191
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
 
LVL 16

Author Closing Comment

by:Jerry Paladino
ID: 31566696
Thanks Jim...  I appreciate your help... Have a great weekend!  -  Jerry
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 24070227
Happy to help Jerry!

And you have one too.

Jim
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Dateadd 3 22
Access 2016 Merge Tables 8 29
Loop within Select Case 3 26
Why is my report opening in "MAX" view? 7 10
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now