hide contents of a table

25 Oct 2005 8:26 PM

Bill M

I have a table with sensitive data (IE: social security number, pricelists)
and need to have this table secured so that the contents can not be read.
However, the data needs to be used in certain queries and reports.

What is the best way to secure the data in the table? I know you can hide
the objects, but any good access hack can easily bypass that. It also seems
that user level security still leaves the tables readable.

25 Oct 2005 8:34 PM

Joan Wild

You can go a long way at obscuring things with Access security (including
denying all access to the tables) and interface restrictions. That will
keep the honest and idle curious out, however if you need strong security
agains hackers, you should consider a server based system - SQL Server.

--
Joan Wild
Microsoft Access MVP

Bill M wrote:

Show quoteHide quote

> I have a table with sensitive data (IE: social security number,
> pricelists) and need to have this table secured so that the contents
> can not be read. However, the data needs to be used in certain
> queries and reports.
>
> What is the best way to secure the data in the table? I know you can
> hide the objects, but any good access hack can easily bypass that.
> It also seems that user level security still leaves the tables
> readable.

26 Oct 2005 2:26 AM

TC

Um, posting the same question twice, a few minutes apart, under
different subject lines, is not the way to go. Someone will answer one
of those questions, then see that they have wasted their time, because
some-one else has already answered the other one.

TC