Solved

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

Posted on 2009-04-04
5
301 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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…
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…

705 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