"Annette Massie" <an******@co.saint-croix.wi.us> wrote in message
news:c6**************************@posting.google.c om...
I have a database that contains complaint information in regards to
Law Enforcement. They need to have this database secure and out of
reach for all but two users. (including me, they say). In other words,
the data they place in this table is higly sensitive and no one other
then a few users must have access to it. If there are design changes,
they would like to give me access to make the changes and they lock it
down again.
Suggestions on accomplishing this, including 3rd party tools, would be
great. I have read a bit about encryption and it doesn't appear to be
able to accomplish their request.
Thanks for helping!
Since an Access/Jet database is storing the data in a *file*, the only way
to really secure it is to restrict who can access the file. If you use
anything besides a properly secured file system like NTFS permissions, then
all you are really doing is obfuscating and erecting barriers that are
easily defeated by someone who really wants to get past them. And I'm not
talking about professional level hackers, just anyone who would be willing
to spend a few dollars for the tools.
If you want the database itself to provide good security then you need to
store the data in a server-based database like SQL Server or Oracle. You
can still create the front end application in Access if you go that route.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com