Securing hidden tables

B

Barry

Hello,

I have an app that is secured, and I'd like to hide some
of the tables. Most, though not all, of these tables I'd
like some user groups to use. My question is, should I
first secure the application and then change the tables'
attribute to hidden? Is there some other way to change
permissions on secured tables? And while I'm at it, is
there any other implication to hiding tables that I
should consider? Thanks in advance to anyone who replies.
 
A

Art

Hi Barry,
Users should NEVER have access to the base tables.
IF you want them to browse some of the tables, you should
set those tables up in a form using datasheet view.
At a minimum, the database container should be
hidden on startup(Tools...startup) so that they cannot see
the various objects such as tables or queries unless you
intentionally display them in forms.

The Easy Day
 

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

Top