473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Encode/Decode Database

AR
I would like to know more about the Encode/Decode feature available
within MS Access.

This is what I have read from Microsoft Office OnLine:

"The simplest method of protection is to encode the database. Encoding
a database compacts the database file and helps protect it from being
read by a word processor."

Is this recommended as a best practice? What is the impact on
performance? How secure is this? What does it use to encode and
decode the database? And when does the encoding and decoding occur?
Every connection? Every query?

Any help is greatly appreciated. Thanks.

Nov 13 '05 #1
1 21451
It is true that using the Access/Jet Encoding does prevent an average user
opening your database in a word processor and identifying textual data.
However, the encryption is very easily breakable since the random 'Key' is
stored within the file header. Therefore the encoding is 100% reversable
(and a free tool exists to decode the databases on the net).

For your information, the encryption is RC4 and based on a 32 bit key. The
encryption is applied at Jet-page file level (each page in mdb files is 2k
(jet3) or 4k (jet4)) therefore the effect is global to the file rather than
to a 'connection or query' as you asked.

Some other things to consider are that the encryption does slow down
performance (MS say 15% reduction) and the chances of recovering data from a
corrupt encoded database are considerably lower than a non-encoded file.
Also, I would suggest that corruption is also more likely to occur in an
encoded/encrypted database.

Quite simply, do not rely on the Encode/Decode feature of Access in any way
to protect your data. IMO it is quite simply not worth using at all due to
the performance decrease, corruption issues and the fact it is completely
reversable.

Regards,

Wayne Phillips
http://www.everythingaccess.com
"AR" <ad*******@hotmail.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
I would like to know more about the Encode/Decode feature available
within MS Access.

This is what I have read from Microsoft Office OnLine:

"The simplest method of protection is to encode the database. Encoding
a database compacts the database file and helps protect it from being
read by a word processor."

Is this recommended as a best practice? What is the impact on
performance? How secure is this? What does it use to encode and
decode the database? And when does the encoding and decoding occur?
Every connection? Every query?

Any help is greatly appreciated. Thanks.

Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Alexander | last post by:
Hi! I need to write an app that downloads an email (pop3), and saves it to a file. The file should be opened again and parsed to get subject, body, attachments... Inline-images and other...
2
by: Schneider Alexander | last post by:
Hello, I would to encode and respectively to decode string's. Now ist my question: Is there a Funktion into J2SE 1.4 API? Thanks Alexander Schneider
0
by: Hardy Wang | last post by:
Hi all: Anybody has some ready-to-use codes in C# to encode / decode MIME format data? Thanks! -- WWW: http://hardywang.1accesshost.com ICQ: 3359839 yours Hardy
2
by: student | last post by:
Hi all, Can any one help me in finding the solution to convert binary format file (ex: jpeg, bmp) to base64 using vc++ code. any help in this regard would be appreciated. thanks
7
by: sarada7 | last post by:
Hi, Is there a way to encode/decode HTML using C++?? Thanks, Sarada.
1
by: bpnmistry | last post by:
Hello all, current task is to encode-decode the string for the communication between client & server. Are there any functions in C/C++/Win32/MFC that can take string as parameter and return...
3
by: Tim Arnold | last post by:
Hi, I'm beginning to understand the encode/decode string methods, but I'd like confirmation that I'm still thinking in the right direction: I have a file of latin1 encoded text. Let's say I put...
1
by: amrit1123 | last post by:
Hi .. I m working on access project.I want to know about encryption algo in access database.how to encode and decode access database using this encryption technology.
1
by: anonymous | last post by:
1 Objective to write little programs to help me learn German. See code after numbered comments. //Thanks in advance for any direction or suggestions. tk 2 Want keyboard answer input, for...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.