G
Glenda
I have 3 Access apps that run at night. They use several local tables but
most of the tables are through an ODBC connection. When I ran them from my
box I didn't have any problems with the ODBC connection. Now they have been
moved to a server the ODBC connection on one certain table fails everynight.
I've tried to refresh the link and it will work until the app is closed and
re opened. Any ideas on what might be happening to my connection with this
one table?
Is there a way to automate a link refresh when my app opens?
most of the tables are through an ODBC connection. When I ran them from my
box I didn't have any problems with the ODBC connection. Now they have been
moved to a server the ODBC connection on one certain table fails everynight.
I've tried to refresh the link and it will work until the app is closed and
re opened. Any ideas on what might be happening to my connection with this
one table?
Is there a way to automate a link refresh when my app opens?