Refreshing ODBC links

[bgseib]

I am using ACCESS as the front end and SQL server as the backen. I am using ODBC to link about 20 tables through ACCESS. My question is: I want to run some sort of a script when you start the application to refresh the links to sql server. What and where would that code go?

Thanks,
BS

 

[bgseib]

Not trying to be mean - But did I ask a really hard question? I don't know half as much as most on here about ACCESS, but I did not think it was a really hard question. If it is just let me know so I will know to seek knowledge somewhere else?

Thanks,
Brian