By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,469 Members | 2,402 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,469 IT Pros & Developers. It's quick & easy.

Automatic ODBC Connection

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.