Recent content by DaveFromNH

I just tried that, and it did not ask for the password. Must be saving it. I've got a work-around now. Thanks for your help.

I've been able to get around this problem with a bit of a radical approach... I found a Microsoft KB article about "How to create a DSN-less connection to SQL Server for linked tables in Access" - the KB article is 892490 in support.microsoft.com/kb (Since I don't have much history with this...

Thanks - I tried, but I'm still getting the same error. When I go to the dsn in the ODBC administrator, the connection does test successfully, I'm just not able to override the PWD parameter... I appreciate your effort.

I built it through ODBC administrator. My problem is that I'm unable to supply the password through code.

I have an SQLServer database on a remote server which is used by our web site. I have a set of reports which I built using MSAccess 2010 and I use ODBC to link to that SQLServer database. I want to build a "Package Solution" to distribute the MSAccess database, but I don't want to give the...