We recently brought up SQL Server and migrated our Access 2000 back end DB to
it.  The SQL Server security seemed pretty straight forward to me...I set up
the users and the roles and assigned the roles rights to my tables.  The
problem is that my users get a Permission Denied error when ever the Access
2000 front end tries to access any SQL Server table unless I add them to the
System Administrator server role.  I've gone over everything and I can't seem
to figure this out.  The only thing I can find that seems strange is that on
that database, my login name is associated with the "dbo" name.  I think that
makes me the owner of the db and I'm wondering if that is what is causing my
issue.  I'd greatly appreciate any insight on how to get this issue taken
care of.
Thanks in advance!
Jim