ADP bound forms and security

  • Thread starter Thread starter Bas Wanders
  • Start date Start date
B

Bas Wanders

Hello,

Is there any way to have bound forms and not having to grant direct access
to tables with ADP.

When using SP's, views or functions as a recordsource of your form you
still needs to set edit permissions on your tables if you want your users
to edit the data via your bound form.
Is there a solution for this? (besides having the forms unbound).

Thanks!

Bas
 
This is the main weakness of not only ADP but also of all ADO' things. No
wonder that Microsoft has dropped this whole thing (ADO) in the .NET
Framework.

You can try using Views with VIEW_METADATA and INSTEAD OF Triggers but I
never tried this personally with ADP.
 
Thanks Sylvain,

I'll check out the VIEW_METADATA + trigger trick.

Best regards,

Bas
 
Back
Top