How do I join another workgroup after updating to Office 2007?

[Guest]

After Converting a database file from Access 2000 to Access 2007 I can not
find a way to join the workgroup file originally used for the database. It
automatically uses the default system workgroup file. How can I join the
correct workgroup file.

 

[Joan Wild]

Did you convert to the mdb or the accdb format in 2007? If the latter,
security is 'no more' in accdb. It is still supported in the mdb format.

If you're using the mdb format, you can change the workgroup via
Database Tools...Administer...Users and Permissions
or from code
Docmd.RunCommand acCmdWorkgroupAdministrator

The preferred method though, is to create a desktop shortcut that specifies
the workgroup file to
use
"path to 2007msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"

 

[Guest]

I am using the .mdb format.
I did get this to work by creating a form with the code below. however, when
I am trying to assign the workgroup in the properties of the shortcut it will
not allow me the length of charecters I need to complete the path of the
workgroup file.

How can I get the shortcut to work while assigning the shortcut to the
workgroup file?

Thanks for your help.

 

[Joan Wild]

That's a limitation of a shortcut. Can you move either/both the mdb and the
mdw higher in the folder structure and shorten their paths?

 

[Guest]

I shortened the folder name and that allowed me enough character spaces.

Thanks for your help.

 

[Guest]

This info helped me out GREATLY!!

thanks.

Did you convert to the mdb or the accdb format in 2007? If the latter,
security is 'no more' in accdb. It is still supported in the mdb format.

If you're using the mdb format, you can change the workgroup via
Database Tools...Administer...Users and Permissions
or from code
Docmd.RunCommand acCmdWorkgroupAdministrator

The preferred method though, is to create a desktop shortcut that specifies
the workgroup file to
use
"path to 2007msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"