ODBC Connection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
If you haven't filled in the appropriate credentials in your DSN, you should
automatically be prompted when you go to use it.
 
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
 
Sorry, I'm not sure. It may be possible using ODBC API calls, but I don't
have information on them handy.
 
Maybe I'm just displaying my ignorance, but how about just opening a
"dummy" recordset:
SELECT * FROM MyTable WHERE False;
 
Back
Top