Solved

MS Access 2010 Exclusive Access Error when viewing report

Posted on 2014-09-09
3
338 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Valid email addresses 6 21
DCount using "OR" 4 18
Acess 2010 - Pause Until Part Of Event Completes 14 25
Error in SQL Query 36 36
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

757 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

21 Experts available now in Live!

Get 1:1 Help Now