exclusive access error and adobe add-in

[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 <Rou...@discussions.microsoft.com> - 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?

[Ed Picillo]

I have a client that has the same problem. Did you ever figure this out??

Ed P

[Mike]

Thanks to the help of this newsgroup I have figured out the answer. First
off, it IS the Adobe toolbar that is creating the problem. Second, to fix it,
on the computer running Adobe, open the Add/Remove Programs dialog from
Control Panel. Click on Adobe 7.0 Standard/Professional, and click
"Change/Remove". Chose "Modify" from the wizard and when it gets to the
optional plug in page, chose the "Create Adobe PDF" item, then "Adobe
PDFMaker" item, and then click the "Access" item and choose "This feature
will not be available." This removes the toolbar plugin from Access and the
problem will be resolved!