odbc

[DD]

i use access to connect to as400 files via odbc. when certain queries are
run, it asks for user id and password to make the connection to the as400.
now on some computers it only ask once for the day. on others it requests
user name and password anytime something is selceted from the database. i
have this database distributed on pc's and thin clients. with some of the
pcs and thin clients, i dont have issues. on other pc and thin clients i
have the issue. i copied the configuration file for the as400 connection
from my pc which works fine, to another pc that has issues. this still did
not resolve the problem. does anyone have suggestions.
thanks

 

[Arvin Meyer [MVP]]

Here is the best site for connection strings:

http://www.connectionstrings.com/access

If they don't work, it must be a problem with the permissions for those
machines that you are having issues with. I'd ask the AS400 admin to check
on that.