exclusive access error and adobe add-in

J

JohnC

I have this exact same scenario. It is new and seems to be related to when
we installed Adobe 7.0 Standard/Professional.

We have an MDB on a LAN file server. Using Access 2K and Windows 2K. When
the application is opened by someone, it seems that if one of the Adobe 7.0
(Standard or Professional) users susequently open the application, they get
the error - "...You do not have exclusive permissions to the database.
Changes that you make may not be saved.." or something like that.

I am one of those users runnning Adobe Acrobat 7.0 Professional. I am
almost 90% positive that the problem is with the toolbar. The application
was designed to load a custom toolbar that has only one button. I think
Adobe is somehow forcing itself into the toolbar, which it does on the Adobe
7.0 users. Does it do this by using a custom Class and by going in design
mode? Seems like this would cause the error. If one user has the
application open, subsequent users would get the same error if somehow they
initiated design mode.

I have been pulling my hair out on this. User's without Adobe 7.0
Standard/Professional do not get the error. Adobe 7.0 Standard/Professional
users do not get the error if the are the first to open the database.

Can we disable the Adobe add-in in MS Access? It is really not needed.
Ideas?

John
From: Roundy <[email protected]> - Find messages by this
author .
Date: Mon, 2 May 2005 14:11:03 -0700
Local: Mon,May 2 2005 5:11 pm
Subject: exclusive access error and adobe add-in

I have a database that is stored on the network and is accessed by multiple
users. I have recently started having a problem where I get the following
message


" You do not have exclusive access to the database at this time. If you
procees to make changes, you may not be able to save them later." I am
going
crazy trying to troubleshoot this message that is "new" to us. The person
has to acknowledge the message 15 times and then they are in. As I am going
through the troubleshooting process I am realizing that my complaints are
mostly limited to users machines on which i installed Adobe Acrobat Writer
7.0 standard. I noticed that it adds a toolbar to Access for exporting
reports.


I did a few things that have helped some, but have not resolved the issue.
I installed SP-3 for Office 2000, and installed the latest update from
Adobe.
Now I get the error message once. I read online that user's need full
control of the folder the file is stored in, but we have never given users
that, and we have not had this problem in the past.


If I open access and then choose open and browse to the file and
specifically select open and NOT open exclusively, it opens without error.
If however I use a shortcut or just browse to the file and double-click it
gives the error message. I think that the adobe add-in somehow tells access
to open the file with exclusive rights.


How can I disable the Adobe plug-in for ms access to see if that will
resolve the issue? How can I get rid of this message? Is there a switch I
can put in the shortcut that would specify just to open the file and not
open
it exclusively?
 
S

Scog

I'm getting the same thing.

If I open a database from a shortcut (to the .mdb file itself) I get
the "exclusive rights" warning / error. If I open the same file through
Access (2003 by the way) - no problem.

This only occurs on machines with Acrobat 7 (ie NOT the reader, the
full prog.)

heeeeeeeeeeeelllllllllllllllllllllppppppppppppp
 
G

Guest

I have the same problem. It depends definitively to Adobe 7.0 (Full Version).
If you have installed this Version, each Access Database seems to be opened
first in exclusiv mode to install some entries in the Menubar. If you are the
first user opening the database, it works. If you are the second (or more)
user or if you don't have permissions to open the database exclusively, you
get the described error.
At the moment, I've nothing found to prevent Adobe to "do this"
 
G

Guest

I was able to fix this by breaking the Adobe add-in for Microsoft Access.
The reason is that Adobe wants the database open with exlusive access in
order to do its magic. It seems I found out where the add-in file was,
deleted it and then started access again. It attempted to re-install the add
in but I canceled it and that seemed to break it for me and I have not had
any further issues.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top