Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2009-04-04
5
Medium Priority
?
323 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

580 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