OK,
there's something I'm obviously missing here (newbie to this).

In Enterprise Manager I've Created a new role on my database called FinanceStaff.

I've added my login as a member of this role (SQL is using NT Authentication)

From Access I run this view

SELECT IS_MEMBER('FinanceStaff') AS Member, SYSTEM_USER AS SystemU, CURRENT_USER AS CurrentU

and get the following results:
0, MYDOMAIN\USERNAME, dbo


Can someone help me understand why the Member column is returning 0 instead of 1?

What am i doing wrong?

All help gratefully received.

M.

ooooh. OK I think I've found the problem.
It looks like if you're the dbo it doesn't check your membership properly.

Does anyone know if this is a known fault / intentional design?

If the former, is there a fix or a workaround?