connect to Progress SQL92 Driver using VBA

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
 
U

uli hofer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Snowflake to SSIS 0
Connection String - Progress Database 0
VBA - Form Progress 4
Can VBA Plug in ODBC password? 2
Linking vs Importing using ODBC connected database 1
MS Access looks for .mdb rather than Progress schema 7
Connect Access to Sage FR100? 0
Error Linking to VFP Tables 3

Top