469,917 Members | 2,391 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

Automatic ODBC Connection

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.
Nov 12 '05 #1
1 6324
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-----

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Sean Anderson | last post: by
5 posts views Thread by SerGioGio | last post: by
11 posts views Thread by DJJ | last post: by
4 posts views Thread by Andreas Lauffer | last post: by
1 post views Thread by Paul | last post: by
5 posts views Thread by Alec | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.