We recently installed SQL Server 2000 and have upsized our Access back end
database to SQL Server.  I have added all of our users to SQL Servers logins
and assigned them to the proper roles.  We are still using that same Access
2000 front end.  My problem is that anyone who tries to run the system gets a
permission denied error on any table they attempt to access unless I add them
to the "System Administratiors" server role.   Clearly, I do not want to have
to add everyone to that role.  SQL Server security seemed pretty straight
forward to me and I can't figure out what I missed.  I would greatly
appreciate any help that anyone has to offer.

Thanks in advance,
Jim