Protect data in the tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've created tables from importing Excel data, and I want to prevent
readers from accidentally change the data in my Access tables, but still want
to maintain the capability to edit on them if I want to. How should I do
that?

And I also have some forms created by using data from tables, and the data
changes according to what I choose from a combo box control. Again, I need
these forms to be protected, any idea?

Thanks.
 
Vera:

For your first question, I get the impression that the people are viewing
the tables directly. This is incorrect. What you want to do is create forms
to display the data within the tables.

Creating these tables, will then put them in the same category as your
second question...

For forms, you can use the LOCK parameter, to keep fields from being
changed, or set ALLOW EDITS/DELETIONS/ADDITIONS to No, at the form level.
Modifying at the form level will not work on forms with the combo boxes, but
any forms that simply view information, will be fine.

HTH

Sharkbyte
 
You know, unfortunately, my forms have combo box and by selecting from the
combo box, the data in that form change accordingly.
My combo box didn't work once I change the ALLOW EDITS/DELETIONS/ADDITIONS
to No. Is there a better way to protect data and not inhibit my combo box
ability?

Thanks.
 
Again, simply set the fields you want to protect to Lock = Yes, in the field
parameters. For the combo boxes, you will probably want to set them to Limit
To List = Yes, as well.

Sharkbyte
 
Back
Top