harry said:
I was under the impression of i joined a workgroup on one workstation
then this workgroup would would apply to all users who logged on but
this does not appear to be the case.
True enough - it changes the default only for the current user
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Access\Jet\4.0\Engines is
the key that's changed in the registry.
Usually, you don't change the default from the standard system.mdw. Give
users a desktop shortcut that specifies the workgroup to use for that
session. The shortcut target would look like
"path to msaccess.exe" "path to mdb" /wrkgr "path to secure.mdw"
You could even put that shortcut in the All Users\Desktop folder so everyone
uses it.