MS ACCESS Exclusive rights error

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?
LVL 3
bczingoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wiswalldCommented:
Check Tools-Options-Advanced and make sure it is set to shared not exclusive
0
mbizupCommented:
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
bczingoAuthor Commented:
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

mbizupCommented:
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
bczingoAuthor Commented:
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
bczingoAuthor Commented:
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
mbizupCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mbizupCommented:
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
bczingoAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.