We use an ODBC connection to an AS400 for our Primary BackEnd Database. In an Access DB, I use an Append Query to select the records from a table in the Access DB using empty values in the fields to be updated from the AS400 BackEnd. Then I use an Update Query for this update.
I know that the connections work correctly, as I can use a Select query and get exactly what I'm looking for. I can't do this in one step, as my key field sizes don't quite match.
My question is: How do I enter the "Update To" field to access the AS400 fields? I've tried the entire connection string and all the portions thereof. It always puts whatever I enter in quotes and then updates exactly that to the field. I end up with the connection string in the Last Name. Any suggestions?
I know that the connections work correctly, as I can use a Select query and get exactly what I'm looking for. I can't do this in one step, as my key field sizes don't quite match.
My question is: How do I enter the "Update To" field to access the AS400 fields? I've tried the entire connection string and all the portions thereof. It always puts whatever I enter in quotes and then updates exactly that to the field. I end up with the connection string in the Last Name. Any suggestions?