Cud not delete the record from the database

[Amish Maske]

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

[d.paulson]

Jusr issue a 'yourrecordset.cancelupdate'.

David Paulson

[coolbiz]

As what d.paulson reply, you're locking the table as you've done some modifications but not yet committed. Either do the .Update or .CancelUpdate before deleting.

-Cool Bizs