SQL Server security

[zloc]

Hello everyone

Does anyone know something about implementing SQL Server security in
MSAccess Project ()adp front-end ?
How to use SQL server DB roles to grant rigts on Forms controls ?

thanks in advance

 

[Sylvain Lafontaine]

Excerpt if you are willing to go into some very extensive programming, you
cannot fine tune the security rights for the forms and reports of an ADP
project against SQL-Server. For all practical purposes, the access rights
for the account used in the login (File | Connection) is what you get as the
access rights for all Forms /Controls /Reports.

Of course, you could try things like Application Role to further define the
access rights for each forms /controls /reports; however, if you try to do
this from ADP, probably that you will be hit by an incredible amount of
problems/bugs.

The newsgroup for ADP is m.p.a.adp.sqlserver .