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?