Shortcut does not join secure workgroup

[Sietske]

I've made a shortcut from the desktop to join a secure workgroup and start
Access for only one session. However, when checking the current workgroup, I
see that I still joined the standard and insecure system.mdw.

My shortcut looks like this:

"C:\Program Files\Microsoft Office\MSACCESS.EXE" /WRKGRP
G:\Data\Access\SecureGroup.mdw

Did I do something wrong? Or is it correct what I did, and do I see the
standard workgroup because my shortcut only joins the secure workgroup for
one session?

 

[Joan Wild]

I've made a shortcut from the desktop to join a secure workgroup and start
Access for only one session. However, when checking the current workgroup, I
see that I still joined the standard and insecure system.mdw.

My shortcut looks like this:

"C:\Program Files\Microsoft Office\MSACCESS.EXE" /WRKGRP
G:\Data\Access\SecureGroup.mdw

Did I do something wrong? Or is it correct what I did, and do I see the
standard workgroup because my shortcut only joins the secure workgroup for
one session?

Bingo. The shortcut doesn't change your default workgroup, it just overrides it and uses the target specified one for that session. Tools, Workgroup Administrator will always show you what your default is set to.

If you want to confirm the workgroup currently in use, open via your shortcut, hit Ctrl-G and type the following in the immediate window
?DBEngine.SystemDB

 

[Tom van Stiphout]

On Tue, 26 Feb 2008 05:25:01 -0800, Sietske

You forgot to include the full path to the MDB/MDE.

Workgroup security is an advanced topic. From your description that
you can run the app while joined to the standard system.mdw it follows
you did not apply it correctly. You have to download, study, and fully
understand the security FAQ from microsoft.com before proceeding.

-Tom.

 

[Sietske]

Joan and Tom, thank you both for your time and your reactions.

Since I posted the question yesterday, I've continued to read the documents
"How to secure an MS Access Database" of Keith Wilby, and "How I Use
Microsoft Access User-Level Security" of Jack MacDonald more closely.

I will follow Toms advice and read the Microsoft FAQ first, and then get to
the advice of Joan.