Mohamed Singh
asked on
MS Access Table Encryption
Hi,
I seek assistance to encrypt the fields in all tables in an external MS Access 2007 database.
The encryption is to be performed on MyDropBox.accdb from MyDeskTop.accdb
We can assume that the path for both files are C:\
The following would not be encrypted:
- AutoNumber fields
- USys Tables
- Tables whose name has a suffix "_NFE"
The attached Encryption.mdb shows the code for different algorithms which I believe would have originated from http://www.frez.co.uk/Free/vb6code (or as adapted, can't recall where Encryption.mdb was downloaded from).
The second attachment CRijndael-fix-bug-with-256
I would prefer to go with the Blowfish encryption, but if it is more expedient, then either of the algorithms in the attached samples would suffice.
Your assistance is greatly appreciated.
Kind Regards,
Mohamed
Encryption.mdb
CRijndael-fix-bug-with-256-bit-k.accdb
I seek assistance to encrypt the fields in all tables in an external MS Access 2007 database.
The encryption is to be performed on MyDropBox.accdb from MyDeskTop.accdb
We can assume that the path for both files are C:\
The following would not be encrypted:
- AutoNumber fields
- USys Tables
- Tables whose name has a suffix "_NFE"
The attached Encryption.mdb shows the code for different algorithms which I believe would have originated from http://www.frez.co.uk/Free/vb6code (or as adapted, can't recall where Encryption.mdb was downloaded from).
The second attachment CRijndael-fix-bug-with-256
I would prefer to go with the Blowfish encryption, but if it is more expedient, then either of the algorithms in the attached samples would suffice.
Your assistance is greatly appreciated.
Kind Regards,
Mohamed
Encryption.mdb
CRijndael-fix-bug-with-256-bit-k.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have a very unique set of conditions there...
Not sure what approach might be "Best", ...as Access does not really lend itself to field level encryption.
About the best you can do in Access natively is to add an input mask of "PASSWORD" to the field in the table, ...this will display the value as something like this: *****
Doing this with code you found online might be problematic because I am unsure if those utilities can "drill down" to the field level in an access database.
Even if it could, how you actually manage the encryption is unknown to me.
I would go with what pdebaets posted first...
https://www.experts-exchange.com/questions/28443655/MS-Access-Table-Encryption.html?anchorAnswerId=40097028#a40097028
JeffCoachman
Not sure what approach might be "Best", ...as Access does not really lend itself to field level encryption.
About the best you can do in Access natively is to add an input mask of "PASSWORD" to the field in the table, ...this will display the value as something like this: *****
Doing this with code you found online might be problematic because I am unsure if those utilities can "drill down" to the field level in an access database.
Even if it could, how you actually manage the encryption is unknown to me.
I would go with what pdebaets posted first...
https://www.experts-exchange.com/questions/28443655/MS-Access-Table-Encryption.html?anchorAnswerId=40097028#a40097028
JeffCoachman
<<I would go with what pdebaets posted first...>>
I would do that as well...just use the built-in DB encryption, which was beefed up in A2007.
There is a performance hit, but it's more than adequate to protect the data.
Jim.
I would do that as well...just use the built-in DB encryption, which was beefed up in A2007.
There is a performance hit, but it's more than adequate to protect the data.
Jim.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You Gentlemen,
I'll have to ponder further.
Your responses are appreciated.
Kind Regards,
Mohamed
I'll have to ponder further.
Your responses are appreciated.
Kind Regards,
Mohamed
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.
I have recommended this question be closed as follows:
Split:
-- pdebaets (http:#a40097028)
-- Jeffrey Coachman (http:#a40097319)
-- Scott McDaniel (Microsoft Access MVP - EE MVE ) (http:#a40098636)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
MacroShadow
Experts-Exchange Cleanup Volunteer
I have recommended this question be closed as follows:
Split:
-- pdebaets (http:#a40097028)
-- Jeffrey Coachman (http:#a40097319)
-- Scott McDaniel (Microsoft Access MVP - EE MVE ) (http:#a40098636)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
MacroShadow
Experts-Exchange Cleanup Volunteer
ASKER
Thank You both for responding.
The following should answer both questions (hopefully):
- This particular project is governed by certain restrictions viz.
- the project must be MS Access. This follows from some succession planning where the user is being trained in MS Access following the demise of a key staff member.
- there are existing applications which are being consolidated & these are in MS Access
- The main back-end will not be encrypted. DropBox, in this case, is only being used for the posting of data from a
remote branch. The data, however, needs to be consolidated and reported by the head-office.
So not all tables would be posted to DropBox, just those relevant to reporting, or settings that need to be
monitored.
- The user feels the need for an additional layer of security owing to the sensitivity of the data, hence the field level
encryption.
- The file posted to DropBox will be password protected in the MS Access convention way.
Hope this explains the particular circumstances.
Kind Regards,
Mohamed