Solved

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

Posted on 2009-04-04
5
273 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

914 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

19 Experts available now in Live!

Get 1:1 Help Now