How to Password for Open in Exclusive Mode

[edisonl via AccessMonster.com]

Hi,

Anyone gotten any idea ow to set password for user open in exclusive mode ?

Regards & God Bless, Edison

 

[Tom van Stiphout]

On Mon, 27 Apr 2009 00:38:36 GMT, "edisonl via AccessMonster.com"

That gets complicated; why not simply create a shortcut with the /excl
command line switch:
<path_to>msaccess.exe <path_to>your.mdb /excl

-Tom.
Microsoft Access MVP

 

[edisonl via AccessMonster.com]

Hi

Erm.. Tom thanks for replying but is there a more specific detailing on how-
to ?

Regards & God Bless

 

[Tom van Stiphout]

On Mon, 27 Apr 2009 03:45:13 GMT, "edisonl via AccessMonster.com"

What part did you not understand?
-Tom.

 

[Joan Wild]

Right-click the desktop and choose New..Shortcut
Browse to the location of msaccess.exe (usually in C:\Program
Files\Microsoft Office\Office folder)
Let the shortcut wizard complete.
Right-click the new shortcut and choose rename (give it a meaningful
name if you didn't before)
Right-click the new shortcut and choose properties
On the 'Shortcut' tab you'll see a 'target' line
Click at the end of that textbox and add a space followed by
<path to your database.mdb> /excl
Substituting the correct path for your mdb file.

Joan Wild
MS Access MVP