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.