All Access files using the secured mdw file

[HConrad]

One more problem, right now all of my databases are
accessing the secure mdw file, even though I have not set
security for them. I try resetting the mdw file for those
to the default system.mdw file, but then it changes the
settings for the secured database as well. Clearly I'm
changing the default file somehow. How can I fix this?

Thanks!

Heather

 

[Lynn Trapp]

You must use the default system.mdw file for your unsecure databases by
JOINING that file using the workgroup administrator. What version of Access
are you using? You then use a shortcut for your secure databases that points
to the secure.mdw file. The basic syntax for the shortcut's target is

"FullPathToMSAccess.exe" "FullPathToYourDatabase.mdb" /wrkgrp
"FullPathToSecure.mdw"

--
Lynn Trapp
MS Access MVP
(e-mail address removed)
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

 

[HConrad]

Thank you for your help. When I was securing the database
originally, it created system1.mdw, system2.mdw, etc. So
I guess the Access files were not then going to the
correct default file (simply system.mdw).

Heather