Locking a form for input - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Locking a form for input

Dag Ekholm

4 years ago

I am missing one very simple and obvious thing in the Simple Security video. When a user is looking at the data on the form, it is still possible to change a record by just typing something into a field on the form, and this change will be saved in the table. This seems to be posssible even if it is saved as .accde.

I am worried that some user might accidentally change data on the form (e.g. when trying to do a search). So I would like to lock it to prevent this. How can I do that?

(Working with a database for old photos for a local history society, which will be used by many persons.)

Scott Axton @Reply

4 years ago

Dag -
It is possible to set a form up so that it is view only through the form properties.
The Allow Additions, Allow Deletions, and Allow Edits is covered beginning in Beginner 7

It is also possible to set up where only certain people can edit or add records.
That is covered through out the courses and in depth in the full Security Seminar.

The user level security would require quite a bit of programming. Beyond what I see your knowledge level is based on the courses you have. If you have experience outside of the courses here, you could definitely get it accomplished.

	Scott Axton @Reply 4 years ago
See the Disallow Editing Data video for some beginning help.

	Dag Ekholm OP @Reply 4 years ago
Thank you for the answer!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View