Re: Re-start iSeries Access ODBC connection from MS Access

Phil,

I didn't have an Access application but it was a Windows based one that had a scripting language in it and I just tested for a connection error and, if it failed, then I just started a new connection. Again, this was using a scripting language (basicscript).

It your case, I guess you would have to have a mechanism that will run a routine that will re-link your tables. I assume you are using linked tables. If you are manually linking them now, then write some VB code that handles the linking. If you already have the linking code, then figure out when you want to trigger the connection test, run the test, and then if it fails, invoke your linking code again. Both ends of your ODBC connection are clueless about whether they ARE connected until you use the connection to retrieve data. At that point you need to check the connection status and, if it fails, reconnect (or invoke your connection routine)

That is pretty high level but that is what I would do.

Pete


Mant, Phil wrote:

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.