ODBC Connection using MSAccess 2007

[DELunsford]

Hi All,

I have a 2007 version Microsoft Access database.
This database has a ODBC linked table in it.
I also have created a query that gets its data from the linked table.

The first time you run the query, Access attempts to connect to the linked table. When this happens Access pops up the ODBC connection window so the user can supply the connection information (Database, Username, Password, etc...). When the window pops up, all the information is already entered into the fields, except for the password. After you enter the password and click the OK button on the window, then the query runs.

My problem is that i do not want the user to see this ODBC connection window. I do not want the user to have to type in the password and click the OK button every time the query is ran.

:confused: Is there a way to supply the query with this information, so that the query will run without popping up the ODBC connection window ???

Any answers, advice, or comments will be greatly appreciated !!

Thanks in advance for any help.

[olivthill2]

Edit a key in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<dsnname>\Password

See http://forums.oracle.com/forums/thread.jspa?threadID=307726 .

Additionally, there is also the MSysConf table. See http://support.microsoft.com/?kbid=209502 .
There is also the workgroup information file, System.mdw. See http://support.microsoft.com/kb/209120 .

[DELunsford]

Thank you olivthill2, this worked like a charm !!!