Access and ODBC

RS6000 mini-computers are a 'totally different animal' than Windows PCs entirely.

What you need to do:
1.) Export the RS6000 database to a .csv (comma delimited file) or other common format that Access accepts. (You'll have to consult your RS6000 database docs/expert/IBM to accomplish this.

2.) Import the common-format file into Access

That's how we did it, only we used MS SQL Server instead of Access.

The program you have that allows you to create an ODBC datasource should provide tutorials/procedures/docs on how to utilize it IF you need a 'pseudo-realtime' connection.
That RS6000 program is proprietary to the company you purchased it from. ONLY they can help you, unless you find someone using the EXACT same program in asimilar scenerio.

If you can create an ODBC DSN to your datasource and connect succesfully from MSQuery, then you can use exactly the same DSN with Access and some ADO code:

Dim sConString as String
Dim conRS6K as ADODB.Connection

'replace dsnName, userName, userPassword with the actual values
sConString
= "Provider=MSDASQL;DSN=dsnName;UID=userName;PWD=userPassword;"
conRS6K.ConnectionString = sConString
conRS6K.Open

You can then execute commands and return the results into ADO recordset objectsDim rs as ADODB.Recordset
'execute your SQL command
Set rs = conRS6K.Execute("SQL Statement")

Glen

Where did you get "Provider=Transoft;"? In my original answer, I said to use "Provider=MSDASQL;" Have you tried that? It's the ODBC provider for AOLDB. I have no Idea what "Transoft" might be...

Glen