Connection to AS400 with ODBC

You would have to set the forms recordsource to the passthrough query.
 
Hey KeithG --

I got the PassThrough query and Append query to work as designed...finally! Just one thing keeps occurring when the query runs, a window opens up asking me to Select Data Source. I have to choose the data source I created, then everything works great. Any idea how to stop this from happening?

Also, I tried to assign the PassThrough query as the Record Source at the FORM level, but it won't take the assignment. The Select Data Source window keeps looping, and I have to end Access via Task Manager to exit. Any clues on this one?
 
You need to go into the Pass through queries properties and set the the ODBC connection string. If you click on the ... to the right it will pop up the conneciton wizard.
 

Users who are viewing this thread

Back
Top Bottom