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
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:
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
