Database encryption

[Prasanth P]

Hello Everybody,

Does anybody have a solution to encrypt data stored in an MS ACCESS database
,so that the data can be viewed /edited or deleted only through an
application and when the data is viewed directly,it should be in an
unusable(or encrypted)
format.

Thanks in advance,
Prasanth P

 

[TC]

That's exactly what Access encryption does!

Of course, the database must be secured using Access user-level security.
Otherwise, any user can run the "decrypt database" command. And, there are
hacks for user level security, so a person who has one of those, could
perhaps decrypt it anyway.

If you are storing data which is important enough to require "industrial
strength" encryption, you should probably be using some other data store;
not MS Jet (the default data store for Access).

HTH,
TC