how i change privilege on a db table: select , insert, delete, update ? access 2003

It is better to think in terms of the way to control these things in forms, Users interact with foms. If you have to control it at the table level your front end needs work. If you are serious about security the control is set in SQL server to prevent people using "the back door", but the front line of permission control should be active in the forms. Use VBA in the procedure that open the form.

You could assign an individual permission for every user for every form. But it is easier to set a security level for each user. Each form has a security level and a user must always at least meet this level to open the form. It is quite easy to hide controls on forms on the basis of the security level. So a supervisor can see more infomation in exactly the same form as the employee.

A convenient place to hold the security level of an object is the Tag Property. The on Load event runs a procedure to compare the security level of a control against a global variable representing the current user's security level and set the visible property.

This allows a data entry operator to use the same form as the supervisor.

I have a TABLE but only appear with select can...(java se6/access 2003) when use insert although shows success data added database do not change (DSN use), well how I change privilege on a db table to appear added data (briefly) ???