I have Access databases that link to tables in the AS400 and SQL. Most of the users are on a thin client server, and some are on PC's. My problem is, everytime I run a query against the AS400 table it asks for the password.
I've created SYSTEM DSNs on each server and checked the 'save password' when linking to the table. When I open the Access database on a different server I have to enter the password again. I have no problem with the links to SQL.
I've read alot of answers on this site about pass-thru queries and some with systems programing, but I'm not understanding where to put the code and which parameters to change.
Appreciate the assist.