General discussion

Locked

ACCESS DATABASE SECURITY

By jmcgaughan ·
I have developed several VB6 applications to control our test stations and dump the test results into tables in two databases. The test stations do not have MS Access on them, so I?m not worried about them corrupting these databases. My concern isother engineers, management, and basically anyone who wants to look at the data, corrupting the data when they are viewing data and writing queries to find the information they want.

I essentially have three groups to contend with; the test stations with full read/write capability, myself and my boss with full rights to do anything, and all others who want to look at the data. This last group I would like to keep from changing anything in the database. I would like them to be able to write queries, so they can find the information they want, but not allow them to change anything in the main tables and queries used by the test stations.

I have read about the security features in Access, but am not sure if I can do what I need, since the book seems to show only if I release an Access application. There is no Access application as such, just people using Access to look at the data, and the test stations running programs written in VB6 which save data and query data.

Does anyone have any suggestions or know where I can find information on how to accomplish this?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

ACCESS DATABASE SECURITY

by sl-campbell In reply to ACCESS DATABASE SECURITY

I have answered questions similar to this several times in this forum, so do a search on my handle.
Basically, you need to do 3 or 4 things:
1. Set the permissions you want
2. Revoke all permissions for Admin that you do not want general users to.
3. Change the Owner to a unique name that only you know

The next step can be done 2 ways depending how many users groups you need, or if the default is enough
First Way:
4a. Add the users and groups with the different permissions that you want them to have.
4b. Ship the System.MDW along with the MDB, putting it into the same folder as the MDB.

Second Way:
4a. Do not ship the system MDW. The users of Admin have now the new limited rights no matter what System.MDW they use, because the actual permissions are stored in the MDB.
4b. Give your Boss the owner ID and the original System.MDW. An Owner can always get full permissions.

Now you can have users join the MDW using the Workgroup program that was installed with ACCESS, or use a switch to point to the correct MDW when starting the MDB.

Collapse -

ACCESS DATABASE SECURITY

by jmcgaughan In reply to ACCESS DATABASE SECURITY

Poster rated this answer

Collapse -

ACCESS DATABASE SECURITY

by sl-campbell In reply to ACCESS DATABASE SECURITY

I have answered questions similar to this several times in this forum, so do a search on my handle.
Basically, you need to do 3 or 4 things:
1. Set the permissions you want
2. Revoke all permissions for Admin that you do not want general users to.
3. Change the Owner to a unique name that only you know

The next step can be done 2 ways depending how many users groups you need, or if the default is enough
First Way:
4a. Add the users and groups with the different permissions that you want them to have.
4b. Ship the System.MDW along with the MDB, putting it into the same folder as the MDB.

Second Way:
4a. Do not ship the system MDW. The users of Admin have now the new limited rights no matter what System.MDW they use, because the actual permissions are stored in the MDB.
4b. Give your Boss the owner ID and the original System.MDW. An Owner can always get full permissions.

Now you can have users join the MDW using the Workgroup program that was installed with ACCESS, or use a switch to point to the correct MDW when starting the MDB.

Collapse -

ACCESS DATABASE SECURITY

by jmcgaughan In reply to ACCESS DATABASE SECURITY

Poster rated this answer

Collapse -

ACCESS DATABASE SECURITY

by sl-campbell In reply to ACCESS DATABASE SECURITY

So, what isn't working for you?

Collapse -

ACCESS DATABASE SECURITY

by jmcgaughan In reply to ACCESS DATABASE SECURITY

Poster rated this answer

Collapse -

ACCESS DATABASE SECURITY

by jmcgaughan In reply to ACCESS DATABASE SECURITY

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums