03-26-2009 01:29 PM
I have successfully connected to ACTReader and have established a DSN to reference so I can link to the ACT tables. My problem; When I run my queries imbedded in VBA code for the first time or after a period of iniactivity, the query fails - - > the Access database is not connected.
What should be used and how? OpenDataBase? Other?