.... then you work either with fixed username / password combinations, or you may consider to make a form in MS Access to let the user specify his/her role, which you may translate into a SET ROLE statement.
Make everything as simple as possible, but not simpler! - A. Einstein
DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool