Set Table Level Password (not through Code)

  • Thread starter Thread starter Warren
  • Start date Start date
W

Warren

Is there a way to set a password on a table-by-table
basis, so even if the users go behind the interface to
access various tables (which they are allowed to do), I
can prohibit them from using a select few number of tables?

Thanks
Warren
 
No, Access doesn't support that type of security. There may be some third
party items that purport to do so, but I don't really know. To achieve what
you wish:

1. Implement Access security. Don't just click the Security Wizard button
.... download and read-read-read the Access Security FAQ (from the MS web
site), Google on "ms access security setup" or something similar and spend a
couple of days reading over posts (pay particular attention to ones my
Michka, Joan Wilde, Tony Toews, and anyone else with an MVP behind their
name) .

2. Setup your database to use RWOP queries, then disallow ALL access to your
tables. Allow access to your queries depending on need. Again, Google on
this and do your reading.

Access security is not a simple issue; it's complex and full of gotchas for
the newbie. Do yourself a favor and make a copy of your database before
trying this.
 
Back
Top