how to give partial access to the database?

[simba]

I have an access 2003 database with front end and back end. The backend is in a server and a copy of the front end, in 20 users' pcs.

The database has information, about the resources available and I am planning to give write access to 2 persons for making new entry / edit.

There is also a caller tracking information, to track who called and what kind of information they were seeking. But all the 20 users, should be given access, to enter the callers' data like, name,address and so on.

Is this something possible?

[pkstormy]

Yes but you'll need to code this into the forms in the frontend.

[simba]

Yes but you'll need to code this into the forms in the frontend.

Thank you stormy. I figured that out. You can say "Allow Additions: yes/No" and "Allow deletion: yes /No".

But for this one, we have to do this individually, in each one's PC. Correct me if I am wrong.

[pkstormy]

You may want to look at the code (in the code repository) or elsewhere which grabs the user's loginID automatically and then you could utilize this in your code.

I often setup a 'user' type table which holds loginID's and security levels. When a form is opened, I'll check to see if what security level that loginID has and then either make the form editable or not.

Here's an example from the code repository if you're interested:
https://www.accessforums.net/code-re...mple-7538.html