Home All Groups Group Topic Archive Search About
Author
29 Apr 2009 2:17 PM
tsluu
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.

Author
29 Apr 2009 9:54 PM
Douglas J. Steele
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)


Show quoteHide quote
"tsluu" <ts***@discussions.microsoft.com> wrote in message
news:AB15BD6B-1D08-4757-918B-E01DB1A69C88@microsoft.com...
> 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.