could not update, record locked.

J

JT

Hi guys,

I have created a database that runs over a big net work some times I get a
message "Could not update; record locked" I have found a solution which is
as follows

Dim cn As New ADODB.Connection
cn.CursorLocation = adUseClient

The problem is where do I put this bit of code so that it will work. I have
some knowledge of VB for applications but sometimes I just don't know where
to put stuff I have found on the net. If anybody has a better fix then
please let me know.

Thanks in advance.

Jan T
 

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

Similar Threads

Could not update; Record locked 0
Record locking problem 0
code placement 4
where do I insert this code? 0
Don't understand Microsoft's work around 7
Exporting data with vba from Excel to an Access 2007 db with password 8
Oracle Connection String 1
could not update;currenty locked 1

Top