Solved

MS Access 2010 Database Engine Could Not Lock...

Posted on 2013-02-06
7
299 Views
Last Modified: 2013-11-27
Hey friends,

My users are getting errors now with Access 2010 that they didn't get in previous versions.

There are times that I will be working on some queries in a separate .mdb file with links to the same BE that my users have and they will get an "Database Engine Could Not Lock... " error message. I'm not in the table design, just the query design.

Does any one know of a way that I can work in my copy of the .mdb and still let my users save data to those back end tables? This wasn't a problem in earlier versions.

Thanks for any help you can give me.

Eddie
0
Comment
Question by:eantar
  • 3
  • 2
  • 2
7 Comments
 
LVL 84
ID: 38861408
If you're working with linked tables, then they shouldn't have any locks placed on them.

More likely is a permissions issue. All users must have at least Modify permissions on the folder hosting the database file. Even if you think you've checked the permissions - check them again, and then get someone else in the IT department to check them yet again.

Also be sure that a stray .ldb file is not floating around. Have everyone close out of the application and check the BE folder to see it a file with the .laccdb extension remains. If it does, delete it. If you can't delete it, then reboot the machine and see if it goes way.
0
 
LVL 5

Author Comment

by:eantar
ID: 38861437
Hey, thanks.

All the forms that they are using for data entry are set to Record Locks: No Locks. Is that what you mean?

Could you explain a little more about the permissions thing?

Remember that they have no problem till I have MY COPY (separate .mdb) open and I'm working in the Query Designer. That's when they get the "Could not lock" message.

E
0
 
LVL 57
ID: 38861454
<<My users are getting errors now with Access 2010 that they didn't get in previous versions.>>

  Depends on how far back were talking about.   Microsoft made a fundamental change in order to reduce corruption; you need exclusive Access to make design changes in a DB.

<<I'm not in the table design, just the query design.>>

 Note though that the table is still open even in query design.  I'm not sure why that should interfere with your users though, unless their trying to get exclusive use of a table.

 Follow what LSM suggested; check the basics first.

Jim.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 84
ID: 38861718
All the forms that they are using for data entry are set to Record Locks: No Locks. Is that what you mean?
No, I'm referring to Windows Permissions. If you are the one locking the database, then I'd start by reviewing the permissions of your user account for that network share.

It's also not uncommon for a corrupted user profile to cause issues like this. To test that, try logging in (on the same machine) as a different network user and see if you can perform the same tasks (you many have to temporarily create a new test profile on that machine, of course).
0
 
LVL 57
ID: 38861772
<<All the forms that they are using for data entry are set to Record Locks: No Locks. Is that what you mean?>>

 and FYI, "no locks" doesn't mean no locking at all.  It means no edit locks.    Locking is still occuring with records/pages with a form set that way.

Jim.
0
 
LVL 5

Accepted Solution

by:
eantar earned 0 total points
ID: 38915555
Hi all,

This error goes away when I take of the Lock Option in the OpenRecordset method of a DAO database in my vba code.

So I found the solution. But I'm willing to give points to anyone who can clearly explain this to me, or point me to an article I can read up on. All the best. E
0
 
LVL 5

Author Closing Comment

by:eantar
ID: 39680239
No one was really able to tell me why. So I'm closing the question.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now