[AccessD] SQL Server as a BE

http://articles.techrepublic.com.com/5100-10878_11-5035150.html

http://articles.techrepublic.com.com/5100-10878_11-5054470.html

http://articles.techrepublic.com.com/5100-10878_11-5061727.html?tag=rbxccnbtr1

http://articles.techrepublic.com.com/5100-10878_11-5068954.html?tag=rbxccnbtr1

http://articles.techrepublic.com.com/5100-10878_11-1061781.html?tag=rbxccnbtr1

http://articles.techrepublic.com.com/5100-10878_11-5055543.html?tag=rbxccnbtr1

http://articles.techrepublic.com.com/5100-10878_11-5083541.html

======I think that's it.

Susan H.

----- Original Message ----- 
From: "Dan Waters" <dwaters at usinternet.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, May 19, 2009 9:23 AM
Subject: Re: [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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com