How to link to Sysusers table?

[lorirobn]

Hi,

I'm not sure if this is the correct forum for my question, but here goes.

I am at a point where I'm putting in user permissions into my Access database. I've read in threads that I can get the information I need from the sysusers table.

I link my Access Front End to back end tables on MS SQL Server. From Enterprise Manager, I see the sysusers table and can read it (not update). But from my Access database, I do not see sysusers. When I try to either import it or link to it, it is not listed on the list of my database tables. The only 'system' tables that are listed are dtproperties, sysconstraints, and syssegments.

Is there a way to access my sysusers table?

If there is another forum that is more appropriate for this question, please let me know and I'll re-post there.

Thanks in advance,
Lori

 

[lorirobn]

As an additional "fyi", I am starting my use of permissions with a command button on one of my forms that deletes a record. I only want my manager to be able to use this button. I am using 'Roles' in SQL Server.