Secure Access 2000 database

"Annette Massie" <annettem@co.saint-croix.wi.us> wrote in message
news:c67abda1.0405100404.424ca357@posting.google.c om...[color=blue]
> 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![/color]

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

Annette Massie wrote:[color=blue]
> I have a database that contains complaint information in regards to
> Law Enforcement.[/color]

What kind of a database could hold so much information?

Annette Massie wrote:[color=blue]
> 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![/color]

Perhaps the simplest way would be to put the data file on a network
shared folder that only those two people have access to (and compile to
MDE, and add workgroup security as an extra layer, although that can be
defeated easily).
--
regards,

Bradley