HI
I am connecting to a table on an AS400 server using the following code:
cn.ConnectionString = "Connect=ODBC;DSN=AS400 AMFLIB;UID=;PWD=;"
rs.Open "Select ITNBR, ITDSC, UCDEF FROM AMFLIB.ITEMASA ORDER BY ITNBR", cn, adOpenDynamic, adLockOptimistic
My problem is that the query is passed to the server and the recordset is sorted in the sortorder that the server uses. I need to have the recordset sorted in the order that access 97 uses.
Can I create another recordset based on the first somehow?
I could do this in access by linking to the table on the server, and then creating a query to sort the results, but I need to accomplish the same thing in code.
Thanks, Derek
I am connecting to a table on an AS400 server using the following code:
cn.ConnectionString = "Connect=ODBC;DSN=AS400 AMFLIB;UID=;PWD=;"
rs.Open "Select ITNBR, ITDSC, UCDEF FROM AMFLIB.ITEMASA ORDER BY ITNBR", cn, adOpenDynamic, adLockOptimistic
My problem is that the query is passed to the server and the recordset is sorted in the sortorder that the server uses. I need to have the recordset sorted in the order that access 97 uses.
Can I create another recordset based on the first somehow?
I could do this in access by linking to the table on the server, and then creating a query to sort the results, but I need to accomplish the same thing in code.
Thanks, Derek