Avatar of Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScFlag for Zambia

asked on 

Access Database Encryption

Hi all

Does it really save any purpose to encrypt a database (BE)with a password when some people are saying there are some free software out there that can break the encryption easily , I know for the FE we seam to be fine as long as we only give clients Accde files.

For queries I'm still using a special code to hide special keys( This is also an extra cover to FE objects), unless someone knows my backdoor hot key it will not be possible to unhide the queries.

Though strictly speaking the software is anchored on queries , VBA code  , macros and reports because even if one steal the tables with entity relation , how is it going to help without the treasured code???

Kindly educate me if I'm wrong!

Regards

Chris
EncryptionDatabasesMicrosoft Access

Avatar of undefined
Last Comment
Jim Dettman (EE MVE)
SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

Protection within MS access serve only one purpose:
Keep "amateurs" from accessing your code, queries, table design and relationships.

Also, keep in mind that MS Access isn't designed for puplic deployment (in other words: designed for internal applications).

If you're looking for more robust security, MS Access isn't the tool for you. Look for compiled languages such as .Net, Java, C++ or C, and better database engines like MySQL, SQL Server, Oracle, postGreSQL ect ...
Avatar of PatHartman
PatHartman
Flag of United States of America image

know for the FE we seam to be fine as long as we only give clients Accde files.
Wrong.  There are companies that will "decompile" the database to produce VBA code.  Earlier attempts produced tokenized code which although it was valid VBA, was very difficult to read because all the variable names were cryptic.  Newer tools produce very readable code with meaningful variable names.
<<There are companies that will "decompile">>

 I'm only aware of one that can do that, and their pretty adamant about proof of ownership, so I would not consider this to be a problem as yet.

 If your aware of more than one, then it would be an issue.

Jim.
Avatar of PatHartman
PatHartman
Flag of United States of America image

I haven't had the problem so I've never had to use the service so I don't know how many companies are out there.  How does one prove they own the app?
<< How does one prove they own the app?>>

 Copyright paperwork, their name is on the app, they can provide some of the source code, etc.

Jim.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo