[AccessD] Fwd: Re: Stop Access Opening Exclusive

To bring this back to the group.

I have compared Kath's Advanced tab with mine and noticed a number of 
options were missing.  Then the penny dropped.  The problem is that 
my database is an adp.  When I create a mdb I can see all the options.

Hopefully the locking problem was to do with the folder and not the database.

Thanks for everyones help.

David


>From: "Kath Pelletti" <kp at sdsonline.net>
>To: "David Emerson" <newsgrps at dalyn.co.nz>
>Subject: Re: [AccessD] Stop Access Opening Exclusive
>
>Sent offline
>----- Original Message ----- From: "David Emerson" <newsgrps at dalyn.co.nz>
>To: <kp at sdsonline.net>
>Sent: Tuesday, July 22, 2008 12:11 PM
>Subject: Re: [AccessD] Stop Access Opening Exclusive
>
>
>>Kath,
>>
>>Can you please send me a screenshot showing your Advanced Tab.  I 
>>am wondering if it is to do with the type of installation of Access.
>>
>>Regards
>>
>>David
>>
>>At 22/07/2008, you wrote:
>>>Strange? I looked at 2003 - it's there on mine.
>>>
>>>
>>>----- Original Message -----
>>>From: "David Emerson" <newsgrps at dalyn.co.nz>
>>>To: "Access Developers discussion and problem solving"
>>><accessd at databaseadvisors.com>
>>>Sent: Tuesday, July 22, 2008 4:50 AM
>>>Subject: Re: [AccessD] Stop Access Opening Exclusive
>>>
>>>
>>> >I have checked on their computer - This property doesn't appear in
>>> > the Tools, Options, Advanced tab (Access 2003)
>>> >
>>> > David
>>> >
>>> > At 21/07/2008, you wrote:
>>> >>David -
>>> >>Might be worth getting your client to check under Tools, Options,
>>> >>Advanced,
>>> >>then check whether the 'default open mode' is set to Shared 
>>> or >>Exclusive?
>>> >>
>>> >>Kath
>>> >>
>>> >>----- Original Message -----
>>> >>From: "David Emerson" <newsgrps at dalyn.co.nz>
>>> >>To: <accessd at databaseadvisors.com>
>>> >>Sent: Monday, July 21, 2008 12:56 PM
>>> >>Subject: [AccessD] Stop Access Opening Exclusive
>>> >>
>>> >>
>>> >> >I have a client that has a shortcut to a database that just has the
>>> >> > name of the database (without the full path of Access before
>>> >> > it).  Windows explorer has the file type associated with Access (he
>>> >> > is running 2003).
>>> >> >
>>> >> > When the shortcut is clicked the file seems to open in 
>>> exclusive >> > mode
>>> >> > so that when another user opens the database it is read only (and a
>>> >> > message appears to tell them).  Since it is an MDE it doesn't matter
>>> >> > as the data in the SQL backend can be changed anyway.  But it is
>>> >> > annoying having the warning message pop up.  How can I change the
>>> >> > shortcut/application so that it doesn't default to exclusive?
>>> >> >
>>> >> > Regards
>>> >> >
>>> >> > David Emerson
>>> >> > Dalyn Software Ltd
>>> >> > Wellington, New Zealand