Exclusive Notice On Opening mdb

5 Dec 2008 6:11 PM

croy

Access 2002 under Windows XP Pro with all patches.

On a split db with user-level security in place and working
well, the users in a custom, non-admin group always get a
message when the log on to the mdb:

"You don't have permission to open '[pathname]' for
exclusive use."

They all use a custom shortcut to open the db, and the
shortcut doesn't use the "/Excl" argument. Folks in that
group never want or need to open the db exclusively. Is
there an easy way to prevent that message?

--
croy

17 Dec 2008 6:09 AM

david

Tools, options, open mode

(david)

Show quoteHide quote

"croy" <c***@invalid.net> wrote in message
news:barij4192b1jr8je9k1t3q5qvn44740cps@4ax.com...
> Access 2002 under Windows XP Pro with all patches.
>
> On a split db with user-level security in place and working
> well, the users in a custom, non-admin group always get a
> message when the log on to the mdb:
>
> "You don't have permission to open '[pathname]' for
> exclusive use."
>
> They all use a custom shortcut to open the db, and the
> shortcut doesn't use the "/Excl" argument. Folks in that
> group never want or need to open the db exclusively. Is
> there an easy way to prevent that message?
>
> --
> croy

18 Dec 2008 3:08 PM

croy

On Wed, 17 Dec 2008 17:09:17 +1100, "david"
<david@nospam.au> wrote:

>Tools, options, open mode

Thanks David.

On this Office 2002 box, there is
Tools|Options|Advanced|Default Open Mode.

That is set to "Shared".

Is that what you were referring to?

To the best of my understanding, that's the best way to set
it for the way we use the mdbs. But often-times, my
understanding lies somewhere between limited, and lunatic.

--
croy

19 Dec 2008 1:32 AM

david

dunno then. Are you sharing the front end? That's not the normal
way to do it. I suppose that if you gave each user a copy of the
front end, they could all have 'exclusive use' permission.

Do you know if the message comes from the MDB or from the MDW?
When possible, I avoid problems by distributing copies of the MDW
as well as copies of the MDB.

Do you know if the message comes after you have started your
application, or before the application is loaded? Sometimes people
put stuff in the startup code that causes an attempt to shift to
exclusive use.

(david)

Show quoteHide quote

"croy" <c***@invalid.net> wrote in message
news:eipkk4t7qpe35osjb2ipbrd4l2pa994grg@4ax.com...
> On Wed, 17 Dec 2008 17:09:17 +1100, "david"
> <david@nospam.au> wrote:
>
>>Tools, options, open mode
>
>
> Thanks David.
>
> On this Office 2002 box, there is
> Tools|Options|Advanced|Default Open Mode.
>
> That is set to "Shared".
>
> Is that what you were referring to?
>
> To the best of my understanding, that's the best way to set
> it for the way we use the mdbs. But often-times, my
> understanding lies somewhere between limited, and lunatic.
>
> --
> croy