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 .