Database queries

[Candi]

I have a database where users can write to it through frontend form only. They do not see the backend database. However, now they want to query the database to run reports. I have no user level security on the database. HOw can I give them access to table where they can just run queires against the database without corrupting the data with their queries?
Thanks for your help!

 

[laxing22]

...HOw can I give them access to table where they can just run queires against the database without corrupting the data with their queries?...

I don't know if my answer will help, but I had / have this problem and made a temp solution. I made a second password protected DB and only allowed a couple of users access that I felt were qualified (it also helps to grab the NT user ID and date stamp on logon in a hidden tables just so you can make them think they are being watched on the DB ) I only link the tables they absolutely need - Beware they can still edit them ! Every time the DB is opened I have a form popup warning not to enter the tables and only use select queries. The DB is backed up nightly (with many historic copies available) and I made sure that department understood the destruction that was possible and it would not be my fault if problems occurred and informed them of how back up were done. I would love to find a better way of doing this exact thing, but this was the best I could come up with.

 

[o1110010]

.. in a hidden tables

what do you mean by a hidden table? have an example either a file or explaination?

 

[Parker]

I have a database where users can write to it through frontend form only. They do not see the backend database. However, now they want to query the database to run reports. I have no user level security on the database. HOw can I give them access to table where they can just run queires against the database without corrupting the data with their queries?
Thanks for your help!

A lot depends on the type of query.

Some write to tables some don't. If you are using append or update, etc. then users need to be able to write to the tables. If they are using select type queries then they don't.

Without implementing some sort of security it is immpossible to stop users finding and altering your tables.

You could use linked tables to spoof the end user but that is all it will do. if they decide that they want to alter a table then they can find the origonal and do so with ease.

In my opinion no db should be left in a state that someone can alter sensitive parts. because if they can they will.

Read up on access security and use it. It is the easiest way to provide any level of reliable security in your db.