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....
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....