Home All Groups Group Topic Archive Search About

You do not have exclusive right

Author
23 Apr 2005 10:39 PM
kenlo
If I open the db from a shortcut on my desktop, The error msg "You do not
have the exclusive right..." will show up and I have to close it by ctrl alt
delete.  If I open Access first and click on the db shortcut, it works fine. 
The db shortcut also automatically opens Access first.  What makes the
difference?

Author
23 Apr 2005 10:48 PM
Douglas J. Steele
Is it possible that the shortcut is trying to open the database exclusively?
Look at the shortcut's properties. Does it include /excl in the string?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



Show quoteHide quote
"kenlo" <ke***@discussions.microsoft.com> wrote in message
news:93512EFA-64E7-4D2A-85F4-CC8D03FEC163@microsoft.com...
> If I open the db from a shortcut on my desktop, The error msg "You do not
> have the exclusive right..." will show up and I have to close it by ctrl
> alt
> delete.  If I open Access first and click on the db shortcut, it works
> fine.
> The db shortcut also automatically opens Access first.  What makes the
> difference?
>
Author
25 Apr 2005 1:49 PM
kenlo
The property does not include the excl string.  The shortcut icon is simply
created from the file, right click and send to desk top.

Show quoteHide quote
"Douglas J. Steele" wrote:

> Is it possible that the shortcut is trying to open the database exclusively?
> Look at the shortcut's properties. Does it include /excl in the string?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "kenlo" <ke***@discussions.microsoft.com> wrote in message
> news:93512EFA-64E7-4D2A-85F4-CC8D03FEC163@microsoft.com...
> > If I open the db from a shortcut on my desktop, The error msg "You do not
> > have the exclusive right..." will show up and I have to close it by ctrl
> > alt
> > delete.  If I open Access first and click on the db shortcut, it works
> > fine.
> > The db shortcut also automatically opens Access first.  What makes the
> > difference?
> >
>
>
>
Author
26 Apr 2005 3:14 AM
TC
You'll get more help if you show the full text of each shortcut
involved; and the full text of the error you get.

HTH,
TC
Author
24 Jun 2005 8:52 PM
Mike
I have the same problem.  I have narrowed it down to being because the
database has a custom menu bar or toolbar.  Try removing the custom
toolbars/menubars and it will work.  Unfortunately, in my case, the custom
toolbars and menu bars are very important to limit the functionality the user
has in the database.  I have developed a workaround but even it still has
issues.  If you create another access database that programatically opens a
new instance of access, opens the database in that new instance, then closes
itself, you will not get the error.  Then you could map your shortcut to that
database.  The problems I have had with this workaround, though, is the
launching database has been corrupted numerous times by users which creates a
lot of maintenance.  Let me know if you find a better solution.

Show quoteHide quote
"kenlo" wrote:

> If I open the db from a shortcut on my desktop, The error msg "You do not
> have the exclusive right..." will show up and I have to close it by ctrl alt
> delete.  If I open Access first and click on the db shortcut, it works fine. 
> The db shortcut also automatically opens Access first.  What makes the
> difference?
>
Author
25 Jun 2005 6:42 AM
TC
Personally, I can't see any way that the presence or absence of custom
toolbars or menubars would affect the error "You do not have the
exclusive right...[to open the database]".

That error is issued before the database has been accepted for opening;
before Access has even /looked for/ customizations such as startup
code, custom menus, & so on.

TC