• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1219
  • Last Modified:

How can I By-pass or auto login to an ODBC database

How  can I By-pass the user id and password prompts or auto login to an ODBC database?
0
mbrennan_pacbell_net
Asked:
mbrennan_pacbell_net
3 Solutions
 
Steve DubyoCommented:
Those details can be embedded.  Is this a linked table we are talking about ?
0
 
mbrennan_pacbell_netAuthor Commented:
Yes,  It is a linked table (Specicially linked into an Access database).

Thanks,

Mike
0
 
jgoedersCommented:
Workspaces(0).OpenConnection("MyNewConnection", , , "ODBC;DSN=...;UID=MYLOGON;PWD=MYPASSWORD")
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
jgoedersCommented:
connect to an odbc database through this code:

Workspaces(0).OpenConnection("MyNewConnection", , , "ODBC;DSN=...;UID=MYLOGON;PWD=MYPASSWORD")

insert the DSN of the database and you logon and password.  then just run this code when the database opens.
0
 
DauheeCommented:
optionally remove the password from the access database :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now