Understanding Scope of MDW's ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi Tom,
Is the activation of Access security and creating of new MDW files
done per MDB ?
Click to expand...


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
 
Back
Top