data encryption

[atlantis43 via AccessMonster.com]

Anyone know details of data encryption for Access 2003. I can't find any
reference in 'help', but I'm sure I've seen something about it in the past.
Richard

 

[Aaron Kempf]

you can use data encryption if you are using ADP

FILE, CONNECTION, ADVANCED

 

[atlantis43 via AccessMonster.com]

I'm using front and back end mdb, but know nothing about ADP. Is it a big
deal to change to ADP?
Richard

 

[atlantis43 via AccessMonster.com]

Now, having looked up ADP in 'help', let me ask some sensible questions:
1)Is there any problem running ADP on a single PC, without any SQL server,
etc. I need data encryption only to be 'HIPAA compliant".
2)Once converted to an ADP, where does the data encryption come from? Is it
available within access, or is it third party software?
3)Can ADP be made simply by importing the elements of my Db into an ADP, or
is there a more complicated requirement?
Thanks, Richard

 

[Tony Toews [MVP]]

I'm using front and back end mdb, but know nothing about ADP. Is it a big
deal to change to ADP?

Yes, it certainly is.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews [MVP]]

Now, having looked up ADP in 'help', let me ask some sensible questions:
1)Is there any problem running ADP on a single PC, without any SQL server,
etc. I need data encryption only to be 'HIPAA compliant".

That may not be sufficient. For example the MDB BE can be downloaded
by anyone onto their own PC, a thumb drive, email or whatever. Then
they can work at thier leisure in decrypting the data. Thus this
might not be good enough for HIPAA.

2)Once converted to an ADP, where does the data encryption come from? Is it
available within access, or is it third party software?

Aaron meant, I think, that encryption is available within SQL Server.

3)Can ADP be made simply by importing the elements of my Db into an ADP, or
is there a more complicated requirement?

Considerably more complicated. Also while ADPs haven't been
deprecated they certainly haven't been improved any.

Also Aaron is a rather difficult person to deal with in the
newsgroups.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[David W. Fenton]

Now, having looked up ADP in 'help', let me ask some sensible
questions: 1)Is there any problem running ADP on a single PC,
without any SQL server, etc. I need data encryption only to be
'HIPAA compliant". 2)Once converted to an ADP, where does the data
encryption come from? Is it available within access, or is it
third party software? 3)Can ADP be made simply by importing the
elements of my Db into an ADP, or is there a more complicated
requirement?

You've been steered in the completely wrong direction by Aaron.

Encryption and ADP are two topics that really have zilch to do with
each other.

Aaron is correct, however, that you're probably going to need a
server back end to maintain HIPAA compliance. A Jet back end is
going to make that awfully difficult except in the simplest
situations (single-user).

Ignore Aaraon. He really doesn't have anything useful to offer you.

My recommendation is that if you must be HIPAA-compliant then choose
something other than an MDB to store your data. If you choose SQL
Server you could use an ADP, but I wouldn't, as Microsoft is
deprecating ADPs (there was never any real justification for
creating them, and MS is now realizing that it was a mistake), so
there is really no future in them.