As/400 linked tables

[Jaco]

Hello. I have linked tables from As/400 and every time I use this tables I
must introduce my password for As/400. How could I avoid that?

 

[Larry Linson]

Hello. I have linked tables from As/400 and every time I use this tables I
must introduce my password for As/400. How could I avoid that?

Generally, that link will be via an ODBC driver, and the link will include a
..Connect property (sometimes called a Connect String). The content of the
Connect String varies by the type of database to which you are linking, but
most Connect Strings have an option to embed the password in the Connect
string, so you would not have to enter the password manually.

I've never used Access with AS/400 tables, so I don't know for certain that
the Connect String has provision for a password, but, knowing that is a
possibility, perhaps you can search for information (either on the net using
your favorite search engine) or at the Microsoft Knowledge Base
(http://support.microsoft.com).

Or, perhaps some kind soul who has used AS/400 tables with Access and knows
whether embedding passwords in the Connect String is a possiblity and the
keyword to do so will jump in and enlighten us.

Larry Linson
Microsoft Office Access MVP

 

[Rick Brandt]

Generally, that link will be via an ODBC driver, and the link will
include a .Connect property (sometimes called a Connect String). The
content of the Connect String varies by the type of database to which
you are linking, but most Connect Strings have an option to embed the
password in the Connect string, so you would not have to enter the
password manually.
I've never used Access with AS/400 tables, so I don't know for
certain that the Connect String has provision for a password, but,
knowing that is a possibility, perhaps you can search for information
(either on the net using your favorite search engine) or at the
Microsoft Knowledge Base (http://support.microsoft.com).

Or, perhaps some kind soul who has used AS/400 tables with Access and
knows whether embedding passwords in the Connect String is a
possiblity and the keyword to do so will jump in and enlighten us.

In my experience you cannot tell a link to an AS400 table to remember the
password. The closest I've come is to loop through all such links at
startup and set the connect property to one that includes the username and
password. It doesn't persist between sessions, but at least you aren't
constantly prompted for passwords during the session.

If they are kept synchronized, you can tell the IBM ODBC driver to use your
Windows credentials and then you are not prompted. There are also ways to
use Kerberos for a "single sign-on" system that eliminates prompts. I find
the latter to be slow however as the background logging in appears to happen
with every single data fetch.