How can I get rid of opening with /WRKGRP system.mda?

[M Skabialka]

I revivied an old database that used this to open it:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"c:\access\oldDB.mdb" /WRKGRP "c:\access\system.mda"

That required me to use a username and password to open it.

I then made the mistake of opening a current database and suddenly it now
requires the same username and password. I don't need the old database,
just some code from it.

How do I remove the username and password completely from the database I use
all the time, and so do a couple of other people? I tried to set the
password to blank but this didn't work. I also tried using

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"c:\access\oldDB.mdb" /WRKGRP "C:\windows\system32\system.mdw"

I can now open the database if I use the system.mdw but I don't want to; I
want to be able to click on it and it opens, which it won't without a
username and password.

How can I fix this mess?

Thanks,
Mich

 

[Connie B via AccessMonster.com]

Is "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"c:\access\oldDB.mdb" /WRKGRP "C:\windows\system32\system.mda"
what you have in the shortcut target? If so, just remove everything beginning
with /WRKGRP and change the database name to the new db file:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "c:\access\newDB.mdb"

If you manually joined that workgroup (instead of specifying it in the
shortcut) then you would need to re-join your default workgroup, but if you
just used the shortcut you should be OK.

If your system.mdw has an Admin user password, then you need to clear the
password from the Admin account. (Tools, Security, Users and Accounts -
select Admin as the user name and then the Clear Password button)