Automatic ODBC Connection

[Paul]

I've searched w/o success for a Macro or Module that can be ran to
automatically make an ODBC connection WITHOUT having to key in the
ODBC password. I'm able to perfrom this manually without a problem,
but am looking for a way to have it run automatically with out having
to tell a hundred users what the username password combination is. Is
this possible?

Thanks for response in advance.

[MGFoster]

Paul wrote:

I've searched w/o success for a Macro or Module that can be ran to
automatically make an ODBC connection WITHOUT having to key in the
ODBC password. I'm able to perfrom this manually without a problem,
but am looking for a way to have it run automatically with out having
to tell a hundred users what the username password combination is. Is
this possible?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Why not use the username/password combination? Isn't that what security
is all about: Only the people (users) who know the password can get in!

That said . . .

DAO (.mdb files): You can open a persistent connection when the
application opens by opening a form (Me.Visible = False) that creates a
connection to the db. This connection uses the UID & PWD paramters.

See this KB article for more info:

ACC: Sample Function to Provide Password for Attached Tables

http://support.microsoft.com/default...b;en-us;109829

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQIQ6soechKqOuFEgEQLEOACfTAhBP1SkTqiWfjYnpAjW5G oA9hsAoNqe
VpOKvolll2PtNXd93y/+CYYP
=Zoo6
-----END PGP SIGNATURE-----