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.