Understanding Scope of MDW's ??

[Tom Glasser]

Is the activation of Access security and creating of new MDW files
done per MDB ? (On my first attempt, it seems that I disturbed
Access security for all MDB's on the entire server!)

Can someone clarify this for me?

 

[Immanuel Sibero]

Hi Tom,

Is the activation of Access security and creating of new MDW files
done per MDB ?

No,

- The use of MDW file is session dependent.
- Every access session uses an MDW
- Out of the box, a session of Access uses system.mdw by default
- You can change this default to another MDW file using wrkgrpadm.
- You can override the default to another MDW file using a command line
parameter


Strictly speaking, all access databases are secured using the system.mdw
(i.e. the default mdw file that comes with Access). So there is no such
thing as activation of Access security.



HTH,
Immanuel Sibero