ADP bound forms and security


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
 
Ad

Advertisements

S

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.
 
M

msnews.microsoft.com

Thanks Sylvain,

I'll check out the VIEW_METADATA + trigger trick.

Best regards,

Bas
 
Ad

Advertisements

S

Sylvain Lafontaine

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adp/sql2k data updatability with a bound form 1
security on ADP 0
Does bound form in ADP still load Jet ? 2
ADP and Forms 1
ADP forms 7
Forms with ADP 9
Secure an adp file? 3
Database Security in ADP 3

Top