How do I implement a security workgroup *.mdw for each database so that when
a user logs into a database, the related security workgroup comes into effect
rather than the normal default one, system.mdw. Reason being, a user might
have individual access rights according to which database they are loggin
into.

Create shortcuts to each database, with each shortcut including the path to
the appropriate mdw file. (There's no other way, since you need the mdw file
before any code starts running)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"tsluu" <(E-Mail Removed)> wrote in message
news:AB15BD6B-1D08-4757-918B-(E-Mail Removed)...
> How do I implement a security workgroup *.mdw for each database so that
> when
> a user logs into a database, the related security workgroup comes into
> effect
> rather than the normal default one, system.mdw. Reason being, a user might
> have individual access rights according to which database they are loggin
> into.