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
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