Encrypt text in Access fields.

[dontaylor]

Hello


I am writing text to a database from a web form and need to encrypt the text in the Access database to ensure that the information is kept secure and only accessable from the web form that is password protected.
Thanks in advance for your help!

[June7]

Access is far from a secure database. An Access mdb or accdb file can be edited by anyone who opens it, unless there is some very sophisticated code that disables editing tools, disables the shift key open, hides the navigation pane, and incorporates password protection.

[AlexHedley]

As @June7 states Access is far from secure, it just takes a little bit if knowledge to break it but there are a couple of things you can do.

Have you thought about scrambling the data with a simple switch. You choose a key and swap the letters, then only the form used to encrypt/decrypt knows what it should be.
Yes this code needs protecting but it's another level deep.
At least the data in the db won't be readable.

Access Data Encryption
http://www.599cd.com/site/courselist...?key=AlexForum

Although this isn't exactly what you need the following seminar may give you some ideas.
Access Security
http://www.599cd.com/site/courselist...?key=AlexForum