connect to Progress SQL92 Driver using VBA

  • Thread starter Thread starter uli hofer
  • Start date Start date
U

uli hofer

I have an Access 2007 database who's sole purpose is to imports data from a
Progress database (linked tables) with a 'Progress SQL 92 Driver'. I
automated the whole importing process with one exception, the password to
access the data in these tables with the ODBC connection.

What is the required VBA code to automate this step too, so the update
process can be scheduled to run automatically during the night?

Thank you
 
Andrew,

Thanks.

Where I have problems with is the required declarations to get the thing
going. I think I can figure out the case specific information. I havn't found
anything VBA specific in the driver documentations I have

Uli
 
Back
Top