Hi All!
I have a problem with Access 97. On a timer each night a piece of code runs which executes a query that imports records from a ODBC connected table and puts them into a talbe in the database. However, despite having a "on error" trap within this code if it encounters a ODBC connection error it still just throws up a fault and hangs there until we arrive in the morning rather than do what I tell it to do through the "on error" trap. Is there anything I can do to control what happens with a ODBC call or in fact for that matter a ODBC time out is encountered or is this simply out of Access's control?
Any help most appreciated.
Dalien51
I have a problem with Access 97. On a timer each night a piece of code runs which executes a query that imports records from a ODBC connected table and puts them into a talbe in the database. However, despite having a "on error" trap within this code if it encounters a ODBC connection error it still just throws up a fault and hangs there until we arrive in the morning rather than do what I tell it to do through the "on error" trap. Is there anything I can do to control what happens with a ODBC call or in fact for that matter a ODBC time out is encountered or is this simply out of Access's control?
Any help most appreciated.
Dalien51
