Solved

MS Access 2010 Exclusive Access Error when viewing report

Posted on 2014-09-09
3
343 Views
Last Modified: 2014-09-24
I developed an MS Access database (not my choice) and developed some reports for the database.  The database is on the server.  When a second user accesses the same report they receive the below error.  

Sometimes the error pops up multiple times.

Can't figure out why or how to resolve.  Any ideas?
Error.jpg
0
Comment
Question by:CipherIS
3 Comments
 
LVL 9

Assisted Solution

by:macarrillo1
macarrillo1 earned 250 total points
ID: 40313607
This can happen a couple of ways:
1. If the user opened MS Access first and navigated to the database they wanted to open. When you open this way you can attempt to open it exclusively.  Notice that the open button has a dropdown (Open, Open Read only, Open Exclusive, Open Exclusive Read Only).  If you open Exclusive no one will be able to open until you exit. In this case you may have to open and close the database to release it.

2. Another situation I have run into is if the database is stored in a directory that does not allow deletes. When you exit Access the lock file is not deleted. Thus MS Access still thinks you are in it.  In this case you need to delete the lock file when you are not in the database and change the permissions to the folder.
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 40313640
For starters ... the  basics:
All professional Access applications use a split configuration, with each user having a copy of the Front End on their workstation. Of course, all FEs are 'linked' to the common Back End ... typically on a Server. This is the tried and proven paradigm ... that will minimize issues. Otherwise, all bets are off.

Meanwhile ... if a user opens an Access db, and is doing anything that Access considers a 'design change' ... for example, opening a Form in Design view, or possibly modifying VBA code and numerous other possibilities  .... then you can incur this error message.

And as noted above ... it's always possible the db was opened in Exclusive mode, but ... that is usually not the case.

Regarding the 'lock file' mentioned above, a 'rogue' lock file (ldb, laccdb) is not likely to cause this problem - typically.  But it is true in general that ALL users must have full Read. Write, Modify and Delete permissions on the folder containing the db. Otherwise, it's possible that or a similar error might be rendered, although that particular error does not usually result from this condition per se.

So ... implement the Split configuration first ... and your issue will likely disappear ... especially since each  user will have a separate isolated copy of the FE on their system :-)

mx
0
 
LVL 84
ID: 40314187
<please no points>
+1 for what Joe said - and also be SURE to note the "each user having a copy of the Front End on their workstation" part. This is critical to success.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

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…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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 use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

863 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

26 Experts available now in Live!

Get 1:1 Help Now