[AccessD] SQL Server as a BE

Hi Susan,

Can you post those links?  I'd like to see them as well.

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, May 19, 2009 7:57 AM
To: Access Developers discussion and problem solving
Subject: Re: [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.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com