Thread: Table security
View Single Post
  #6  
Old June 2nd, 2010, 05:06 PM posted to microsoft.public.access
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Table security

You can disable the database window, the shortcut (right-click) menus, etc.
via the Startup settings.

You can remove the "X" (close this form/window) and maximize the form on the
screen.

If you let the users get "behind" the forms, you better be darned sure they
understand relational database design and the tips/tricks of using Access.
Otherwise, you lead them to believe that tables are just like spreadsheets,
and that they can type anything anywhere.

That's the reason Access offers forms, so you can direct/control what users
see and how they enter/edit data.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Ixtreme" wrote in message
...
On 27 mei, 18:16, "Jeff Boyce" wrote:
How is it that the user can "see"/get to the table?


I am not sure what you mean. But he can just go to the tables,
reports, queries etc by just minimizing the active form.


How does the user know which table to add the record to?


It's more like that I don't want the unauthorized user to add records
to certain tables. Only an administrator should be able to add
records. For example: a combobox contains a predefined list of
Officers. I don't want each user to add new records for the same
person eg. J. White, Jimmy White, J White.

One approach might be to hide the database window and only present forms
to
the user.


Via Tools, Startup? But that can easily be changed by the user right?

Another might be to "hide" the tables.

How do I do that? in VBA? Could you please explain in more detail?