MS Access logging in via ODBC

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

Steve Wilson — Sun, 17 Jan 1999 23:22:06 GMT — source: Informix-list mailing list archive (1991-1998)

Has anyone discovered a way to automatically log in from Access to an Informix database? I have a number of reports written using Access that I would like to give to users, but I would prefer it simply log in to the linked tables, and print out the report. TIA. swilson@NOSPAM.hoida.com

↪ replying to Steve Wilson

Curt van den Heuvel — 22 Jan 1999 05:48:20 GMT — source: Informix-list mailing list archive (1991-1998)

> Has anyone discovered a way to automatically log in from Access to an >Informix database? I have a number of reports written using Access that I >would like to give to users, but I would prefer it simply log in to the linked >tables, and print out the report. TIA. Don't know if anyone answered yet, but you should be able to do this by editing the "connect" property of the linked tables, and supplying a user id and password. The whole string should look something like this: ODBC;DSN=YourDataSourceName;UID=whoever;PWD=youknow;DB=somedatabase -Curt

↪ replying to Curt van den Heuvel

a@b.c — Fri, 22 Jan 1999 04:57:27 -0800 — source: Informix-list mailing list archive (1991-1998)

In article <7893f4$81v@bgtnsc03.worldnet.att.net>, heuvelc@primenet.com says... > > > Has anyone discovered a way to automatically log in from Access to > an > >Informix database? I have a number of reports written using Access that I > >would like to give to users, but I would prefer it simply log in to the > linked > >tables, and print out the report. TIA. > > > Don't know if anyone answered yet, but you should be able to do this by > editing the "connect" property of the linked tables, and supplying a user id > and password. The whole string should look something like this: > > ODBC;DSN=YourDataSourceName;UID=whoever;PWD=youknow;DB=somedatabase > > -Curt When you're linking your tables (in the MSAbcess GUI), there is a checkbox that says something like 'Save Login Information'. Try it. You'll like it.