Using an Access Macro to extract data from SQL database problem

Using an Access Macro to extract data from SQL database problem.  We are using techscheduler to run this macro at specific times.  Every couple days it fails and you have to re-link the tables and then re-run it.  Any ideas what could be causing this to have to re-link the tables.  I checked maintenance tasks.

Thanks
LVL 2
mkurtzhalsAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
why not include a routine that checks the link before running the macro.
if link is broken, relink using codes.
0
 
EMCITCommented:
Chances are its an issue with the SQL db. Is it getting rebooted?
0
 
mkurtzhalsAuthor Commented:
sample code?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.