Nov 3 2007, 12:44 PM
I have a form to display records in my database and it has a delete button to delete the active record. My database uses Access user accounts for multiple different people. The delete button works when I use it (I'm the administrator), but when anyone else tries to use it, they get the following error:
"You do not have the necessary permissions to use the Events Booked object. Have your system administrator or the person who created this object establish the necessary permissions for you."
I've tried setting the relevant user group to have delete permissions on the table from which the data on the form is based, but this still doesn't work.
Does anyone have any ideas what may be causing this?
Nov 3 2007, 06:04 PM
They also must have delete permissions on the Form and also on the Query if you are using one.
Nov 4 2007, 06:12 AM
Thanks for this. I couldn't change the delete permissions for the Form, because the option is greyed out. However, setting the permission on the Query worked. I hadn't realised that this was necessary because my other delete buttons worked straight off, but thinking about it now, they delete data directly from tables, not queries.
Nov 4 2007, 06:31 AM
I was wrong. You only need the form to have delete permissions if you are deleting things on the form, not in a query that you may be running from a command button.
Glad to see you got it sorted. Security can be a bit difficult at times.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here