Secure data integrity

24 Oct 2005 9:48 PM

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

24 Oct 2005 10:41 PM

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.

--
Joan Wild
Microsoft Access MVP

nickheck***@heckmanhealthcare.com wrote:

Show quoteHide quote

> 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