Amish Maske
May 18th, 2001, 08:57 AM
Hi friends..
I'm using this forum after very long time..
but i'm really stuck now... I'm working on VB 6 as my front end and MS-ACCESS as my back end Wat is happening is..I'm opening the connection for a databse using ADO then firing some insert and Update querries on to it.. the point to be noted is that i've yet not Commited any trancastion... and i'm doing it on single opened connection... but when i'm firing the delete querry for deleting the record its giving me the error as "Could Upadate the database; Currently locked"..
can anybody help me how can i perform the delete operation without closing the current session and without committing the transaction...
thanikng u...
Amish
I'm using this forum after very long time..
but i'm really stuck now... I'm working on VB 6 as my front end and MS-ACCESS as my back end Wat is happening is..I'm opening the connection for a databse using ADO then firing some insert and Update querries on to it.. the point to be noted is that i've yet not Commited any trancastion... and i'm doing it on single opened connection... but when i'm firing the delete querry for deleting the record its giving me the error as "Could Upadate the database; Currently locked"..
can anybody help me how can i perform the delete operation without closing the current session and without committing the transaction...
thanikng u...
Amish