0

Hi people. I have a time and attendance module in VB6 which saves transactions (ADO) in MS-SQL if there is a LAN connection, and save it locally (MS Access) when offline. The trigger is when someone logged in. This is what I did:

Set cn = New ADODB.Connection
cn.Open SQLConnectionString
If Err.Number Then
   'Save it locally in MS-Access
   Set lcn = New ADODB.Connection
   lcn.Open LocalConnectionString
Else
   'Save it in MS-SQL
Endif

The problem is, if the LAN failed, it takes so long before the transaction is saved locally. What is the best way to do it?

2
Contributors
2
Replies
4
Views
8 Years
Discussion Span
Last Post by alski
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.