[AccessD] Stop Access Opening Exclusive

Kath Pelletti kp at sdsonline.net
Mon Jul 21 04:26:50 CDT 2008


According to this link:

http://www.gridview.org/kb/Access2003/When-you-run-Microsoft-Access-from-the-Start-menu-or-a-shortcut-menu-you-can-use-command-line-switches-to-modify-the-sta.aspx

which I have been reading myself lately, there is no switch for 
non-exclusive - it is the default.

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
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list