ADP bound forms and security

[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

 

[Sylvain Lafontaine]

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.

 

[msnews.microsoft.com]

Thanks Sylvain,

I'll check out the VIEW_METADATA + trigger trick.

Best regards,

Bas

 

[Sylvain Lafontaine]

The instead of trigger may not be necessary if you have a simple view.