Secure the forms, reports and data from change

[Guest]

In the previous access programs I was able to disable users ability to change
objects and data. I want to do the same in Access 2007, I only want users to
add data, but not to change data that is already there and also not to let
users go into the design of the forms.
Is this still possible?
Thanks

 

[Guest]

you need to do these steps to achieve what you want:
change you form "default View" to Single Form
and change Data Entry from "NO" to "YES" all these changes are in in Form
properties in tabs FORM and DATA

in order user do not make "Desing View" option, you need to change "Shortcut
Menu" from YES to NO in tab OTHER

you can make an Pop Up startup form where you need to link others form, and
protect your main form whith a password to view your desing view


I hope this help you

LD

 

[George Nicholson]

Changing the DataEntry property of all forms to Yes will only alllow users
to add data, not view existing records.

Be sure to specify a startup form and all navigation the user might require.
Then, under startup options, make sure the database window will be hidden to
prevent "free" access to tables, forms, etc. Likewise, disable 'special
keys'.

Making a mde of the frontend will prevent any design changes to forms,
reports, code, etc, even if the user manages to get to them (design views
are disabled). (Be sure to keep a backup of the mdb you base the mde on.
mde's can't be edited.)

Disabling the Shift key bypass would be an additional precaution you could
take.

HTH,