Rastro_Jetson
Registered User.
- Local time
- Today, 03:58
- Joined
- Mar 1, 2017
- Messages
- 12
Hello folks,
I inherited a giant MS ACCDB. It has a little bit of everything in it; local tables, odbc tables, linked network XLSX data sources, zillions of macros, zillions of queries, etc. Currently, I pull the db down to my C:\ drive but all those other links are still active.
When I pull up a SELECT query and start designing it... if I click, say in the criteria line of a field I've added to the query, the db clocks. Spinning circle... Maybe just 5-10 seconds. Next field, click in the criteria line... it clocks for 5-10 seconds.
The db is not running anything that I can see. I've never seen this and it's highly annoying. Any advice would be greatly appreciated. :^)
I inherited a giant MS ACCDB. It has a little bit of everything in it; local tables, odbc tables, linked network XLSX data sources, zillions of macros, zillions of queries, etc. Currently, I pull the db down to my C:\ drive but all those other links are still active.
When I pull up a SELECT query and start designing it... if I click, say in the criteria line of a field I've added to the query, the db clocks. Spinning circle... Maybe just 5-10 seconds. Next field, click in the criteria line... it clocks for 5-10 seconds.
The db is not running anything that I can see. I've never seen this and it's highly annoying. Any advice would be greatly appreciated. :^)