[AccessD] SQL Server as a BE

Yes, but this is specific to interfacing an Access database to SQL Server.

Thanks,

John W. Colby
www.ColbyConsulting.com


Susan Harkins wrote:
> 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.
> 
>