Search results for query: *

BurtanI, Well for the locktype i am using adLockOptimistic and for the recordset It is ADODC. below is a sample code i am using: Dim Retry_Count% Retry_Count% = 0 On Error GoTo Error_Loop If Me.adoReceipt.Recordset.State = 1 Then Me.adoReceipt.Recordset.Close End If If...

I am having too much problems with locking a table or a recordset on a network.I have to upadte 4 tables when doing a save.I tried to trap the errors but it is not working properly.When I test the error trapping code on the network there is garbage being written to tables.I have not been able to...

I am using vb6 Data Report using an ODBC connection. My reports that are static (i.e, Reports generated directly from the database without passing any parameter) is OK. The problem is when I try to insert a parameter in the SQL builder it is not being accepted. The same thing works correctly...

I'm currently developing a system whereby i'm using Adodc connection components. Now my problem starts when i want to update a record whose data must be inserted in many tables at one go. I cannot roolback the transaction whenever a transaction did not occur completely. I know that with ado it...

I am using an Access db in VB 6 and my system is supposed to be a multiuser one.My problem is that i am being able to lock a table or record when two users write to the same table at the same time.I want to prompt one of the user that the table is in lock status.I have tried using the locktype...

I am using an Access db in VB 6 and my system is supposed to be a multiuser one.My problem is that i am being able to lock a table or record when two users write to the same table at the same time.I want to prompt one of the user that the table is in lock status.I have tried using the locktype...