[AccessD] SQL Server as a BE

JC, Mike Gunderloy and I wrote a series of articles on SS security for 
TechRepublic.com. If you'd like to read them, I'll send some links. They're 
very basic/tutorial type articles.

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.