> Phil, I didn't explain myself clear enough. I'm sending data to an Access
> database on a local computer and also to an Oracle database that I'm linked
> to either on the local computer or via a network to an Oracle server.
> If the local Oracle database is shut down or if the internet cable is 
> disconnected then data can't be linked. When the internet cable is 
> reconnected or the local database is restarted then how will the vb app
> know and how will the vb app keep from faulting.
> 
> Use the Error event to control this problem?
> 
> Thanks
> Jeff

Hi Jeff,

Can you also use Transactions to ensure that your entire transaction made
it to the database?

At the beginning of your transaction:
cnn.Begintrans
On Error GoTo JeffError
<do stuff to the recordset and try to Update Access and Oracle>
cnn.CommitTrans

JeffError:
cnn.RollbackTrans

HTH,

Michael