[AccessD] Security & encryption (cross posted to accessd & dba-sql)

Hi Roz:

Yesterday, I was in a seminar that was toting the attributes of SQL 2005.
One of the features was the capability of creating encrypted tables and
whole databases

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Roz Clarke
Sent: Tuesday, May 10, 2005 2:05 AM
To: 'Access Developers discussion and problem solving';
'dba-sqlserver at databaseadvisors.com'
Subject: [AccessD] Security & encryption (cross posted to accessd & dba-sql)

Hi all

This may or may not be slightly OT... We have been asked by our HR
department whether it's possible for us to build a storage facility for
confidential data (such as salary information), that is encrypted and that
neither we nor the network administrators could get into once it's gone
live. Ideally it would be integrated with their current application which is
Access 2002 FE / SQL Server 7.0 BE.

How do I build an encrypted database that I can then lock myself out of
completely?! Without locking everyone else out too (that I've done before). 

Management are willing to spend some money if necessary.

TIA

Roz