Form Error

  • Thread starter Thread starter Mark Schirle
  • Start date Start date
M

Mark Schirle

Hi,
I have a typical front end/back end access97 database. Occasionaly I
lose connection to the backend. When this happens I have problems
opening forms that have list boxes and combo boxes because they load
from a query looking for data on the lost server. Where can I put code
that will catch this error and stop the process gracefully. I put the
code:
msgbox err.number & " " & err.description
in the Form_Error procedure of the form but I just get a 0.
TIA
 
Someone recently asked whether you could code things up to handle
disconnections gracefully, & continue on, storing the data in a local table.
I said no, because I assumed there was no way to recover gracefully from a
BE disconnection. Do you believe that a method based on form-error could
actually do that?

TC
 
TC, I haven't tried, but if you had a local copy of the data, you could
theoretically cancel any updates, close anything that is using data
(forms/reports/recordsets), and reassign the Connect property of each
TableDef.

If you then allow the user to continue updating the data, you have a
scenario that is approaching replication.
 
Back
Top