I need to be able to create a view (uptodate) of certain tables on an AS400.
I can link into the tables using access, ie creating a DSN ODBC connection and then using either a sql passthrough query or simply linking the table.
I am running SQL 7.0 and have created a new database called Product_Codes. How can create a link (view) into the as400, ie corrcet syntax. I know what the library's are and what the tables are but am struggling setting this up