[AccessD] SQL Server as a BE

Also, and I apologize to everyone, I should've included this in my earlier 
response -- we have a SQL Server list. You might get more help there.

Susan H.


In SQL Server they have "Roles". You can still use your Windows 
Authentication but you will have to set up a userid on the sql server for 
each user and then assign them a role. You can set up an Access form to 
assign people roles and pass the T-Sql to set them up through a pass through 
query.