Secure data integrity

[nickheckman]

I need help ensuring data integrity. Here's my situation and I would
like reccomendations on the security that I should implement.
Currently, I've got a database stored on my server that is accessed by
12 users through Windows Remote Desktop. Recently, I've noticed
records being deleted from one of the tables in the db. None of my
users are admitting guilt, but it is my assumption that they have to be
manually deleting the records at the table level. I have no code
written to delete information from this table that has records being
deleted.

For some time now, I have forced users to log in to the db so that I
could track certain actions. As far as I can tell, there is no way to
track what is done at table level. Recently, I used the Access
function of hiding the database window from my users, but this is
easily unhidden by a knowledgeable user. Are there any other methods I
can use to keep my users from accessing the table without also making
them unreachable to myself?

Any help here would be appreciated.

Thanks,

Nick Heckman

 

[Joan Wild]

Since you've implemented security, you should look at using RWOP (run with
owner permissions) queries for all data interaction. You can then remove
all permissions from the tables.

You can also disable the shiftkey bypass, if that's what your knowledgeable
worker is doing.