Make SQL Server db read only for some users

[Ken McLean]

I have a SQL Server database deployed on discountasp.net with a MS Access project file (.adp) as the front end. A pass word is required. How can I allow some users read/write access while allowing other users only read access? Thanks for any suggestions.

Ken McLean