Linked Table Password

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,

Can any one help?

I have Sage Database tables attached within an Access Database via ODBC, the
reason I have done this and not connected directly to Sage is that I need to
run queries against Sage and Access records.

My problem is it keep asking for the ODBC user name and password within my
VB NET app when I run an SQL query.

How can I stop this or pass this information within my connect string.

Thanks.
 
¤ Hi,
¤
¤ Can any one help?
¤
¤ I have Sage Database tables attached within an Access Database via ODBC, the
¤ reason I have done this and not connected directly to Sage is that I need to
¤ run queries against Sage and Access records.
¤
¤ My problem is it keep asking for the ODBC user name and password within my
¤ VB NET app when I run an SQL query.
¤
¤ How can I stop this or pass this information within my connect string.

I don't believe this is possible through ADO.NET. However, there should be a save password checkbox
in the dialog box when you create the link to the Sage database table. You may need to secure your
Access database if you don't want users to have direct access to the Sage database table.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Doh!

Yes your right - I simply disconnected and relinked the table and checked
the box 'save password', and now I can connect to the table through Access
as if it were an Access table, so I can now use all the tricks and
formatting Access allows to query my data.

Thanks.
 
Back
Top