When you open the Access 2003 file using Access 2007, it will using the default mdw file and you lost all of your use security. So what you need to do is create a shortcut and point it to your mdb file and the mdw file like "path to mdb file" /wrkgrp "path to secure.mdw"
After that, you can verify the mdw file is correct loaded by press Ctrl-G and enter the ?SysCmd(acSysCmdGetWorkgroupFile) into to vb immediate windows.
