ODBC Connection

S

Samantha

I have connected data via ODBC using a DSN. Now, I need to invoke the log-in
dialog box when Access database form activates. How can I do this? Can
anyone show me the code to do this on the form?
Thanks in advance.
Samantha
 
D

Douglas J. Steele

If you haven't filled in the appropriate credentials in your DSN, you should
automatically be prompted when you go to use it.
 
S

Samantha

Douglas,
My form only opens the database when a button is clicked to perform a
certain transaction, at which point the log-in dialog box appears. What I'd
like to do is to invoke the dialog box at the activation of the form,
before any transaction takes place, so that they can just sign in once at the
beginning. Any ideas on how I can code this on the form's activiation?
Thanks.
Samantha
 
D

Douglas J. Steele

Sorry, I'm not sure. It may be possible using ODBC API calls, but I don't
have information on them handy.
 
J

John Nurick

Maybe I'm just displaying my ignorance, but how about just opening a
"dummy" recordset:
SELECT * FROM MyTable WHERE False;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top