467,122 Members | 1,243 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,122 developers. It's quick & easy.

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

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
  • viewed: 3668
Share:
2 Replies
Expert 8TB
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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Peter Frost | last post: by
6 posts views Thread by Joerg Battermann | last post: by
4 posts views Thread by David Lozzi | last post: by
reply views Thread by Tommy B | last post: by
3 posts views Thread by tshad | last post: by
5 posts views Thread by prakashwadhwani@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.