Error => Could not save; currently locked by another user.

mike2020

I am using VB 6, ADO and Access in my Apps. I have one table which has a Memo field, and while saving recordset (rs.Update), at that point I am receiving the following error
"Could not save; currently locked by another user."

Any idea, why I am receiving this error?
I will appreciate your response.

Sep 28 '07 #1

Killer42

I am using VB 6, ADO and Access ...

It sounds as though Access is reporting this for whatever reason. You might be better advised to seek information from the Access forum.

Is there any chance that another user (or another application run by the same user) is in fact updating the same info? For example, I've often run into problems trying to run an update program because I had the same table open in Access at the time to check something.

Sep 28 '07 #2

jrtox

I am using VB 6, ADO and Access in my Apps. I have one table which has a Memo field, and while saving recordset (rs.Update), at that point I am receiving the following error
"Could not save; currently locked by another user."

Any idea, why I am receiving this error?
I will appreciate your response.

Hello,
Try to set your RS to
LockType=adLockOptimistic
CursorType = -adOpenDynamic
CursorLocation = adUseServer

if doesn't work
try
Con.Execute "[SQL Statement]"

Regards

Sep 28 '07 #3