Session Locked

S

sukonik

Hello,

I keep getting a error message when i try and import some data via m
forms. The VB that runs in the background imports some data via sq
from some text documents, there is rollback used to. However, every s
often I get 'Couldn't update; currently locked by another session o
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 i
again later on that day

Can I detect this problem and sort it.

Hope you can really help it is quite annoying.

Thanks

Car
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top