Re-start iSeries Access ODBC connection from MS Access

["Mant, Phil" <pmant@xxxxxxxx>]

Hopefully someone on this list can help me out. I have developed an MS
Access database that is linked to a DB2 table on the iSeries. Every 15
minutes the Access Database displays a form with a pie chart that is
generated from the table on the iSeries. The problem is that the iSeries
system shuts down every night for a system backup. This causes an ODBC
error for MS Access and the application has to be restarted. If possible
I would like to avoid having to restart the MS Access application. I
have attempted to find out what code is required to re-start the ODBC
connection, but so far I have been unsuccessful in my search. Does
anyone have any code examples that would accomplish this for me?  

 

Thanks,

Phil.