Dan Waters
dwaters at usinternet.com
Tue May 19 08:23:29 CDT 2009
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