Linked tables

[Mike]

I have a form based on a ODBC linked table. When I open
the form I get a login dialog box. Is there a way to
automically fill in the User ID and Password when the form
is initially opened. (I currentyl working in Access 97)

Thanks

Mike

 

[Douglas J. Steele]

You should be able to specify that in the DSN you're using.

 

[Guest]

Could you be more descriptive.

-----Original Message-----
You should be able to specify that in the DSN you're using.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)





.

 

[Douglas J. Steele]

Not without knowing what DBMS you're going against.

For instance, with SQL Sever, you can specified that you're using Trusted
Connection, or else specify a user id and password.

Or is your question how to find the DSN? That's through the Control Panel.