Form Bound to Data Linked to SQL Asking for Password

M

Mike Thomas

I am new to Access 2000 forms bound to data tables linked to SQL Server 7
via ODBC.

When I run a query from VBA using the connection string which contains the
password and userid, everything is fine.

When I open a form which is bound to a linked table however, a "SQL Server
Login" dialog pops up asking me for a password. I can give the password, or
click cancel, go to the form, and do what I want.

What do I need to do to get these forms to open without opening the dialog
box?

Many thanks,
Mike Thomas
 

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

Similar Threads

Table Security in Access 2013 1
Adding data to MS Access from csv file 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Can I save a sql statement generated by a search form? 1
Error handler not catching SQL Server Connection failure 2
sqlite-odbc write conflict 2
linking to SQL Server db table 6
Testing for Password on a Form 1

Top