Referencing ADO or DAO

craigachan

Registered User.
Local time
Today, 12:26
Joined
Nov 9, 2007
Messages
285
I'm an amature VBA programmer. I have developed a front/back end DB based on Access 2010 which also shares tables thru links to another Sql DB thru ODBC. In my programming, I've never referenced ADO or DAO on any of my underlying forms. I'm wondering if this is necessary since my forms are still working. Lately I have noticed that my program will get delayed (cursor spinning for long periods of time) and will hold up my whole office whether anyone is using my database or any other software program. I have about 20 workstations with 3 side by side servers on a domain, each dedicated to a specific software DB.

So... is referencing ADO or DAO needed and if so, might this be hanging up my program? Your input is appreciated.
 

Users who are viewing this thread

Back
Top Bottom