On 27 mei, 22:29, Jerry Whittle
wrote:
You need to implement User Level Security. That way you can restrict user to
certain forms and reports plus not allow them to even see the tables.

However this is a LOT of work both to set up and maintain. Unless you have a
very valid requirement, such as HIPPA or some other law, to keep users out of
the table, I suggest that you don't sweat the small stuff and allow users
access to things. Just keep frequent backups.

I read the stories about user level security and I must say I am not
very keen on that option. The database is used within a risk
management department. Some comboboxes are restricted to certain
values eg Obligations. I don't want the user to add values by
themselves.