SQL Connection

[tjs206]

I am running an Autoexec macro, that runs my maketable queries, update queries and delete queries, then it runs the transfer spreadsheet macro to a folder that I have created on the root of C on my local computer and then the last thing Autoexec does is close my database.

I have all this run when I double click my database on my desktop.

I want this to be totally automated, just double click and it gives me my spreadsheets. One problem - My ODBC connection to my SQL Server keeps popping up for password. Is there anyway I can put a connection string in my AutoExec macro (maybe a function, then use a runcode macro), so when my queries run and need that ODBC connection the login information already exists?

Thanks.

 

[tjs206]

I answered my own question.

When linking the tables for the ODBC connection, I needed to check the Save Password checkbox.

Maybe this will help someone else.