Home All Groups Group Topic Archive Search About

SYSTEM TABLE THAT STORES USERS

Author
19 Oct 2006 3:55 PM
ftrujill0
is there a system table that I can query to get user name information?

thanks in advance

Author
24 Oct 2006 12:26 AM
Graham Mandeno
The table is not in your database, but in your workgroup (MDW) file.  It is
named MSysAccounts.

You can't get anything from it except the list of users and groups, because
the other data is encrypted.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Show quoteHide quote
"ftrujill0" <ftruji***@discussions.microsoft.com> wrote in message
news:52E73DFA-98B5-457C-9540-97750A5F9A46@microsoft.com...
> is there a system table that I can query to get user name information?
>
> thanks in advance