Opening a secured database on Access 2007

[RBear3]

Hello! I have several Access databases created on Access 2003 or before.
These are secured and use a workgroup file.

I have a shortcut that allows me to open these using the workgroup, or I can
use the Workgroup Administrator to join a workgroup. I can't find these
options in 2007. And, when I try to open these files, I can't.

I could actually unsecure these at work on 2003 and then open them at home,
but I like the idea of securing these.

 

[Douglas J. Steele]

Use the shortcut approach. Joining the workgroup is seldom a good idea
anyhow, since it will apply to all future databases.

 

[RBear3]

I'll have to try it again tonight. When I tried this yesterday I kept
getting errors. Perhaps i have the path wrong.

Thanks!

 

[Douglas J. Steele]

The shortcut must include the full path to msaccess.exe in addition to the
full path to the mdb file and the mdw file:

<full path to msaccess.exe> <full path to mdb file> /wrkgrp <full path to
mdw file>