Change Access 2003 mdb workgroup using Access 2010

[metsmaniac]

I just upgraded to Access 2010 from 2003. With 2003, I was able to open protected mdb files using Workgroup Administrator and joining (changing) the workgroup. This was done BEFORE opening the mdb file.

I can't do this with Access 2010 - there's no option to change a workgroup.

I scoured the internet for an answer. The closest one suggested creating a shortcut and having the target point to the Access application, then the mdb file, then use a "wrkgrp" command to point to the workgroup file (all this in one space-divided string). The answer related to Access 2007, and it doesn't work in 2010 (unless I'm doing something wrong).

Anyone have another suggestion?
Thanks.

[HiTechCoach]

I have always used a shortcut to select the correct work group file.

In Access 2010 try:

docmd.RunCommand acCmdWorkgroupAdministrator

[metsmaniac]

Can you please clarify how & where this shortcut is created? Thanks.

[HiTechCoach]

You create a standard windows shortcut with the target of:

“full path to msaccess.exe” “full path to mdb” /wrkgrp “full path to secure mdw”


For additional information see: Access User-Level Security

[metsmaniac]

I guess the 25th time is the charm. I tried that solution about 2 dozen times last week without success. Today it worked. Probably some keystroke error on my part before.

Thank you very much for your help.

[HiTechCoach]

You're welcome.

Glad to hear it is working for you now.

[SynerSoft]

This was the perfect solution! I created a new db, created a new module, then pasted "docmd.RunCommand acCmdWorkgroupAdministrator" into the immediate window. Success! Now I can address those nasty 64-bit PtrSafe Declare messages!

Thanks again!

-Jay

I have always used a shortcut to select the correct work group file.

In Access 2010 try:

docmd.RunCommand acCmdWorkgroupAdministrator