Community
Showing results for 
Search instead for 
Do you mean 
Reply

Logging on to ACTREADER through ODBC

New Member
Posts: 11
Country: United States

Logging on to ACTREADER through ODBC

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.

 

  • I can "logon" by manually linking to the DSN, supplying an Id=ACTREADER and my assigned passwork and the queries will now work.
  • I would like to write code to connect or login to ACTREADER through ODBC that would be executed when using the database (autoexec or in the Open event of a form)

 

What should be used and how?  OpenDataBase? Other?

 

Thanks,

Jim