Solved

MS Access 2010 Database Engine Could Not Lock...

Posted on 2013-02-06
7
304 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
hit enter key to run macro 13 23
How to use VBA to update a record in a table in MS Access? 12 36
Modal form 11 30
Access VBA, adding Progress Bar in code to allow execution. 7 28
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

770 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