ADP bound forms and security

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bas Wanders - 27 Apr 2005 15:13 GMT

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

Reply to this Message

Sylvain Lafontaine - 27 Apr 2005 16:05 GMT

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.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC

> Hello,
>
[quoted text clipped - 9 lines]
>
> Bas

Reply to this Message

msnews.microsoft.com - 27 Apr 2005 16:29 GMT

Thanks Sylvain,

I'll check out the VIEW_METADATA + trigger trick.

Best regards,

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
[quoted text clipped - 17 lines]
>>
>> Bas

Reply to this Message

Sylvain Lafontaine - 27 Apr 2005 16:51 GMT

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

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC

> Thanks Sylvain,
>
[quoted text clipped - 26 lines]
>>>
>>> Bas

Reply to this Message