Only want one form for users

[Noreene Patrick]

I have checked the forum for security posts and havent quite found what I am looking for...so, here is my question.

I have a database that allows users to input info, supervisers to run queries and reports, etc. Works fine!!! But, the terminal was moved to another place that is out of the way, and we are finding that some users (savvy "wanna be's") are getting into the tables and changing info to give them better percentages (therefore, they will get bonuses!). The problem that I dont know how to get around is that the supervisors are not savvy enough to get around without using the switchboard (that allows them to query the info they need).

So, how do I set up my db that will allow the users to only be allowed to use one form for their input and all the rest of the db is secured with a password, even the switchboard?

I will check back on Monday since it is the end of the day...Thanks in advance for your help.

Noreene

 

[ghudson]

I would first warn the users of the db that falsifying there data records would be grounds for termination! Their actions are stealing money from the company!

Sounds like you need to use Access security since the users are savvy enought to find their way into the db and alter their records to increase their bonuses. Access security will allow you to grant only the access you want the users to have. Ideally you would only grant the users access to the forms so that they are forced to add/edit/delete records in such a way that you control how and what they see and do with the data.

Search the forum for security, system.mdw, work groups, etc. for more info. Please ensure that you make backups of your db before and during this process for you can lock your self out if you are not carefull.

Good luck!