How to set security on forms so that data cannot be deleted?

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

Guest

The security settings allow me to keep data from being deleted in tables and
queries, but not forms! Is there any way to do that??
 
Teri said:
The security settings allow me to keep data from being deleted in tables and
queries, but not forms! Is there any way to do that??
Click to expand...

What security settings? The only security settings I know of that would prevent
you from deleting data from tables would also prevent forms from deleting that
same data.

You could set the AllowDeletions property of the form to No.
 
There are security settings under "tools" - "security", I have set them for
users & groups not to be able to delete, and I also set the "Allowdeletions"
to 'no', but you can STILL delete in the form, which in turn deletes from the
table!
Am I doing something wrong? Thanks, Teri
 
Teri said:
There are security settings under "tools" - "security", I have set
them for users & groups not to be able to delete, and I also set the
"Allowdeletions" to 'no', but you can STILL delete in the form, which
in turn deletes from the table!
Am I doing something wrong? Thanks, Teri
"Rick Brandt" wrote:
Click to expand...

Security is WAY more complicated then just going into users and groups and
changing settings. I'm sure that what you have done there has been a complete
waste of your time.

User level security in Access is a very advanced topic and the vast majority of
people who attempt it get it wrong. You need to go to Joan Wild's web site and
get her explicit step by step instructions to have any chance of getting it
right.
 
Well, I found the website, but I don't see where I would find "explicit step
by step instructions". Please advise. Thanks!
 
Open your form in Design View. Right click on the field you want to protect
and select Properties. Scroll to to the Locked command and change to "Yes".
Save the form and the field is locked for editing or entry. You can still
search, sort, etc. from the field. hope this helps.

Stu
 
Back
Top