Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: hide tables in ADP files

    I have a bunch of tables, views, forms and reports in a ADP file. I plan to distribute this file so that others can use the forms and report. I DO NOT want them to be able to go into the tables and views direclty and mess them up!

    How do I go about hiding the Tables and Views from the other users?

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    You can't really do that.

    Table level security needs to be on the SQL Server.

    The first thing I do, and I'm sure you do this too as you haven't mention security for your forms, is export the adp to an ade. This locks the code and protects the reports and forms.

    Views aren't a big problem, you should always have select only access to anyone but yourself. As the data in a view is read-only, the rest takes care of itself. As for the tables, you can hide them, but it's fairly easily to circumvent for any mildly knowledgable user.

    In short, set the permissions on the sql end. Just because they can SEE the table doesn't mean they can change it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts