- Joined
- May 20, 2008
- Messages
- 1
- Reaction score
- 0
how will i make the forms/all items in MS Access restricted from modifications of the end-user?
there are several times that my programs had been modified by an end-user like changing the colors of the fields background font name size etc. etc. and sometimes they accidentally deleted one of the fields and was not be able to undo, so they will have to call me again because of the problem.
I want to restrict everything on my databse so that no one can modify the program, what they can only do is encode a Record;add,update,edit,delete.but the designing and the modification will only allow me.
i have tried the database password and the account permission but its all the same even if the end-user is logged on (with the permission only applies to user), it can still modify the design/forms same as what the Admin can do.
Please help. Thank you.
there are several times that my programs had been modified by an end-user like changing the colors of the fields background font name size etc. etc. and sometimes they accidentally deleted one of the fields and was not be able to undo, so they will have to call me again because of the problem.
I want to restrict everything on my databse so that no one can modify the program, what they can only do is encode a Record;add,update,edit,delete.but the designing and the modification will only allow me.
i have tried the database password and the account permission but its all the same even if the end-user is logged on (with the permission only applies to user), it can still modify the design/forms same as what the Admin can do.
Please help. Thank you.