|
Home > Archive > MS Access project with SQL Server > April 2005 > ADP bound forms and security
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ADP bound forms and security
|
|
| Bas Wanders 2005-04-27, 9:24 am |
| 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 2005-04-27, 11:24 am |
| 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.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
"Bas Wanders" <bas@wanders.net_nospamplease> wrote in message
news:Xns9645A4F0CC17
Abaswandersnet@207.46.248.16...
> 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
>
>
| |
| msnews.microsoft.com 2005-04-27, 11:24 am |
| Thanks Sylvain,
I'll check out the VIEW_METADATA + trigger trick.
Best regards,
Bas
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:urnuEqzSFHA.628@tk2msftngp13.phx.gbl...
> 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.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
>
>
> "Bas Wanders" <bas@wanders.net_nospamplease> wrote in message
> news:Xns9645A4F0CC17
Abaswandersnet@207.46.248.16...
>
>
| |
| Sylvain Lafontaine 2005-04-27, 11:24 am |
| The instead of trigger may not be necessary if you have a simple view.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
"msnews.microsoft.com" <bas@wanders.net_nospamplease> wrote in message
news:%23fPfw3zSFHA.3548@TK2MSFTNGP10.phx.gbl...
> Thanks Sylvain,
>
> I'll check out the VIEW_METADATA + trigger trick.
>
> Best regards,
>
> Bas
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:urnuEqzSFHA.628@tk2msftngp13.phx.gbl...
>
>
|
|
|
|
|