Session Locked

[boblovesyousomuch]

Hello,

I keep getting a error message when i try and import some data via my forms. The VB that runs in the background imports some data via sql from some text documents, there is rollback used to. However, every so often I get 'Couldn't update; currently locked by another session on this machine'.

There isn't another session running though!!

I have closed my recordset and db and set to nothing.

it normally happens if somebody imports data and then tries to do it again later on that day

Can I detect this problem and sort it.

Hope you can really help it is quite annoying.

Thanks

Carl

 

[vbajock]

Are you closimg all the objects properly? Ig you post some code I might be of more help