Security File (.mdw)

[Guest]

Please forgive me if this message is a little verbose. Is there a way to
link a specific "Security.MDW" file to ONLY ONE MS Access Database? I
created a secure database but when I close that database and open ANY OTHER
database I am still attached to the same security file. Once joined, the
security file becomes the default for ALL MS Access databases that open. Is
there a way to access a secure database without making a specific
security.mdw file the default for ALL databases that MS Access could open? I
would rather NOT have to join/re-join the local "security.mdw" database file
every time I want to access a different database other than the secure
database.

Thank you for your time and assistance.

Charles Bender
MTU Detroit Diesel

 

[Joan Wild]

Please forgive me if this message is a little verbose. Is there a way to
link a specific "Security.MDW" file to ONLY ONE MS Access Database? I
created a secure database but when I close that database and open ANY OTHER
database I am still attached to the same security file. Once joined, the
security file becomes the default for ALL MS Access databases that open.

That's the nature of the beast. You have to be joined to *some* mdw by default.

Is
there a way to access a secure database without making a specific
security.mdw file the default for ALL databases that MS Access could open? I
would rather NOT have to join/re-join the local "security.mdw" database file
every time I want to access a different database other than the secure
database.

Rejoin the standard system.mdw that ships with Access, as your default. Create a desktop shortcut to launch your secure mdb. The target would look like:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

 

[Guest]

Joan,

I can understand that MS Access requires an mdw file to open (even if it is
not a secure database). However, is there a way (create a module perhaps)
that a database can attach to a specific "security.mdw" file when it is
opened then release it and return to the local default .mdw file?

Thanks in advance for the information and I am hoping something can be
worked out because it is a real pain in the @$$ to keep changing between .mdw
files.

Charles Bender
MTU Detroit Diesel

 

[Guest]

Joan,

Please disregard my previous message regarding specifying which mdw file to
start with the database. If I learn to READ then I would have noticed that
you ALREADY ANSWERED this question.

Thank you for all your time and assistance.

Charles Bender
MTU Detroit Diesel