How do I pass authentication information between Access and Iseries ODBC linked table?
I have a table linked from Microsoft Access to an Iseries file using the Iseries ODBC driver. I then have an Access data access page that uses a query to display rows from the table. I want to automate the authentication process to the Iseries. I have tried to create a file DSN in the ODBC driver and then include UID/PWD information, but this does not seem to be working. I also went into table design from Access and modified the table properties (description attribute), again no luck. The table contains non-sensitive information, so I have no concerns over suppressing the need for the user to authenticate.