How to avoid prompting of AS400 user name and password when running queries based on linked table in an Access program?
Posted on 2013-01-20
I need help in automating the part when a user has to input his userid and password every time he runs the access program, is there some function which can be used to store the users id, password, AS400 server details for connection so that the user only needs to save them once?
There will be several linked tables so he will have to enter the id and password depending on the number of links and queries.
MS Access version is 2010