Setting ODBC Password? 1

[AlexCuse]

Hi All,

I am trying to schedule a task to run during off hours to update a table. It is basically an autoexec macro set up in an access database. This macro turns off warnings and runs a query that uses linked tables to build a new table that replaces an existing table in a third database. The source of the data is a SQL 2000 db and the other two databases involved are .mdbs.

Windows login will not work, so I need to figure out how to make the database connect to this particular ODBC connection without me being here to enter my password. Any help will be greatly appreciated.

Thanks in advance,

Alex

 

[VicM]

Alex,

When you first link the tables from the SQL db thru the ODBC, there is a check box which allows you to store the password in the connection string to the SQL tables.

In order to use this function, you will need to delete the links to the SQL tables and then go thru the Get External Data routine. When you select the list of tables in the SQL db, be sure to check the box for saving the password.

When the db opens, there will be no prompt for the password to the SQL tables as the PW is now stored in the connection string.

Hope this helps,

Vic

 

[AlexCuse]

Wow, after all the times I've had to link to different tables how did I not notice that box? Have I become conditioned to immediately look for complex programmatic ways to accomplish even a simple task such as that?