Access 2003 is bypassing my workgroup file

[kirnavi]

I've had a workgroup and secured databases for a few years now in Access 97. A few days ago, we converted all databases to Access 2003. Everything was working fine up until about a few hours ago. Now Access (everyone's) is bypassing the workgroup, even though the workgroup administrator says that it's still pointed to the correct workgroup file, and signing on everyone as Admin. Unfortunately, since Admin doesn't have rights to a lot of stuff, there are a number of users who can't get to their data. I can't get to it either since I can't sign on with my login and password. I've tried moving the system.mdw in case Access was defaulting to the machine's MDW for some reason but that's not working. Also booted everyone out of Access to see if it was some weird multi-usage thing but that didn't work either. Any ideas???

 

[willir]

Create a shortcut for access to the database that includes the workgroup.

For example...

"C:\Program Files\Microsoft Office\Office\MSAccess.exe"
"C:\My Documents\TestDatabase.mdb" /wrkgrp "C:\My Documents\SecureGrp.mdw"