Solved

MS Access 2010 Database Engine Could Not Lock...

Posted on 2013-02-06
7
298 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

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…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

746 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

12 Experts available now in Live!

Get 1:1 Help Now