Solved

MS ACCESS Exclusive rights error

Posted on 2007-04-09
9
452 Views
Last Modified: 2013-11-15
in msaccess  a user all of a sudden gets a exclusive error message. ( the changes u make may not be saved) - This only happens after the splash screen closes and an (unbound) menu form opens.
The use can sign in with same name and pw onm another machine with no problems - On the original machine though no one can log in wo error-
There is a shared system.mdw
We have given user fresh copy of .mdb - there are only links to SQL server tables which can be accessed manually-
Any ideas?
0
Comment
Question by:bczingo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 13

Expert Comment

by:wiswalld
ID: 18876047
Check Tools-Options-Advanced and make sure it is set to shared not exclusive
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18876070
Is the user able to enter/update data normally after clicking OK to the Exclusive Access message?

We had a similar issue with shared databases on a few computers.  In our case, the problem turned out to be related to Adobe Acrobat Professional 7.0, which was attempting to add toolbar buttons to Access's menu.  We removed the add-in, and the problem was solved.  Possibly worth looking into...

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21956484.html#17333295
0
 
LVL 3

Author Comment

by:bczingo
ID: 18876209
wiswalled - 1st thing we looked for - thanks anyway
mbizup - will look into this - am skeptical because all machines get upgraded the same - will report back
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 61

Expert Comment

by:mbizup
ID: 18876269
Since this looks like a machine specific issue, check for differences in software configurations between this machine and others that work (other software that might attempt to add buttons to Access's menu might have the same effect).  

Also see if the users can enter data after clicking okay (possibly many times... our users counted 31 'okays')  to the exclusive access message.
0
 
LVL 3

Author Comment

by:bczingo
ID: 18876717
thanks everyone - user is not available now...(figures) will get back to u after trying-
1 note - the menu form that opens and gives error is unbound but does try to intialize menubars - gonna try commenting those out .... we will see
0
 
LVL 3

Author Comment

by:bczingo
ID: 18899370
well - it seems that avery label maker steps on access dbs- it installs a toolbar that wants rights it cant get - progeram needs to be entirely uninstalled - tried 3 different installs on more then 1 machine - Trying to get help from Avery
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 18900700
Take a look at the steps I posted at the end of that other thread.  If you can't get help from Avery in a timely fashion, you should be able to do somthing similar with Avery's Access add-in.

- Go to add/remove programs from your computers control panel
-  Look for the Avery Software
-  Once you have add/remove programs for the Avery software, look for a list of "add-ins" and find Access among them.  Remove the Access add-in.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18917887
Given the information and feedback you provided, what additional details did I need to give for an "A"?  Please read the grading guidelines here:

http://www.experts-exchange.com/help.jsp#hi73
0
 
LVL 3

Author Comment

by:bczingo
ID: 18923829
mbizup:
I'm not sure where you want me to look for a list of add-ins.  I don't see anything in Add/Remove programs.  Nothing that specifically says 'add-ins' inside the MS Office setup.  Inside Access there is nothing listed in the Add-In Manager.  The only thing I see on the program list is under Office Tools, MS Access Snapshot Viewer.  I'll be happy to look wherever you say.

0

Featured Post

MongoDB Through a MySQL Lens

This article looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

632 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