deny users direct acces to tables

  • Thread starter Thread starter Fatboyslimro
  • Start date Start date
F

Fatboyslimro

Hi all
I want to deny users to enter information directly in the table ( through
"tables" tab in ADP ), and allow this only through forms.

I've observed that if I disable the select permission the table becomes
invisible but the form it's not working because it's using the select
command.

I'm not the programmer - I'm just the network admin.

thanks for any reply
 
The only way you can disable direct access to tables is by allowing access
only via stored procedures and views. Forms are not on the server, so you
can't give them access to the table without simply giving the user permission
to access the table. Of course, with an ADP front-end, even the stored
procedure technique will have problems unless you use all bound forms as
read-only and create unbound forms for updating data.

When you get to that point, it may be just as easy, and result in a more
maintainable application, to simply write Windows Forms programs in .NET.
With, you also have the option of controlling access using a middle-tier
rather than just using SQL Server security.
 
Back
Top