Recent content by Chillgeek

Oh my god ........ gemma ....... you are gem really :-) ....... I just looked into my code and for some strange reason I am using adLockOptimistic instead of the usual adLockBatchOptimistic that I have been using all these years ........ thanks buddy !!

you are right gemma.. thats ADO. I too thought of a buffered write taking place but do you know of a way of forcing the commit in this situation? Your help will be greatly appreciated friend.

Thanks Gemma, I am not running any queries as you say and I am not using procedures at all. Here is the code sample, If rsItmDtls.EOF = False And rsItmDtls.BOF = False Then For i = 1 To rsItmDtls.RecordCount...

Dear All, I am facing a strange problem off late with the MS Access database. After Insertion of records, I close the recordset and not the connection as I use a global connection, which is set at the time of the app launch. Now, after closing the recordset I move on to the next job in the...