Help with Permissions

  • Thread starter Thread starter John Garner
  • Start date Start date
J

John Garner

I currently have a secured database used in my
organization. Each user has a front end database on their
local drives and there is a backend database that houses
the tables. Currently, I have given the users the ability
to open the database exclusively on their local machine.
I have given the users group all permissions except the
ability to delete data (modify design of forms, tables,
etc).
When a member of the users group tries to update a record
on one of the forms, an error message pops up saying he
does not have permission to modify the form/table;
however, the information is updated in the table as he
does have permission to update data. Does anyone know the
reason why members of user group get this error message?
Is there a way to stop the message from appearing, as the
information is updated regardless of the error message?
The whole point of securing the database was to prohibit
members of the users group from deleting data. If I give
permission to modify table design as the error message
states they need, they will be able to delete data, and
therefore, renders my securing the database a useless task.
Thanks for your help in advance....
 
Permission to modify the design of a form, does not automatically grant
permission to delete data from the table on which the form is based.

Tell us the exact text of the error message that occurs when you try to
update a record via the form. There are hundreds of these messages - we
can't just guess what it is!

TC
 
Sorry for being unclear. To clarify, when a user on the
secured database tries to update a form, the following
error message occurs:
"You Don't have permission to modify form x."
"To modify this object, you must first have modify design
permission for it. If the object is a table, you must
also have delete data & update date permission for it."

As an administrator, when I update, everything works
well. My initial thought is that I have to secure the
back end database as well?? If I secure the back end with
all permissions except delete data for users, will this
error message go away?
Again, thanks in advance for your help....
 
I'm still a bit confused. When you say that a user tries to "update" a form,
do you mean that he tries to change the data of an existing record displayed
on the form? Or is he trying to place the form into Design view so he can
change the actual design of the form?

Your original post suggested the former: "When a member of the users group
tries to update a record on one of the forms".

But the error message suggests the latter; I can't see how: "You Don't have
permission to modify form x." would occur if the user was only trying to
edit data via the form.

Sorry to ask more questions, but I need to be sure what is hapenning, before
I can suggest a solution.

Cheers,
TC
 
Back
Top