Click here to Skip to main content
12,699,492 members (32,350 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB VB.NET
Hello all my brothers,

I want to encrypt the whole access database with
I don't want to encrypt the tables or records in database.
I want to encrypt the whole access database.
Is it possible?
If it is, Please advise me or show me how to do it.
Thanks all and Hoping any helps.
Posted 14-Nov-12 0:11am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Why? There's no point to it.

In order to use it, you would have to decrypt the database for the life of the application session. This completely strips your database of the encryption "protection" allowing anyone to copy/open the database during the time your app is running.

Then, when your app is done with the database, you'd have to re-encrypt it.

But, what happens if your app crashes when the database is unencrypted?? There that data sits, out in the open.

The bottom line is if data security is a concern, don't use Access databases.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Thanks Dave Kreskowiak,

But Actually I am working with SQL DataBase.
to export some tables, We exported into New created Access Database.
the thing I want to do is encrypting that exported access database.
because I don't want user can easily open the database.
I think if i can encrypt the whole database , it will be secure a little for the End_User.
And sorry for my bad English too.
If there is way , please help me.
Dave Kreskowiak 15-Nov-12 0:22am
OK. And after you've encrypted the Access database, then what? You can't use it at all until it's decrypted.
Jewelthet 15-Nov-12 21:23pm
Can't I decrypt before I want to use?
Is like that we can only decrypt after encrypted only in app is running the process?
I intend to transfer these access database with some tables to another database.
Is there something I don't know ??? :( :( :(
Dave Kreskowiak 16-Nov-12 8:12am
You HAVE to decrypt the Access database before you use it.

The rest of your post made no sense at all.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 14 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100