Hi, Ken.
Need code to log the Oracle Database automaticly without type in the Oracle
User Name and Password.
Are you planning to store this Oracle User ID and password in an Access
database, perchance? If so, for your own personal safety, please put this
thought out of your mind. As an Oracle DBA myself, I can tell you that I
don't know of any Oracle DBA -- who has worked long and hard to secure an
Oracle database -- who wouldn't go ballistic when he found out that an
Access database developer couldn't be trusted with the knowledge of a User
ID and password.
For security reasons, the user _must_ authenticate at least once per user
session by typing a User ID and password. Your application can hold these
values in variables, but do not store the User ID and password in the Access
database.
If you choose otherwise, be prepared for many dents in your health record.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
