hide contents of a table

[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.

 

[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.

 

[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