Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
Hello all my brothers,
 
I want to encrypt the whole access database with vb.net.
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
good
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.
  Permalink  
Rate this: bad
good
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.
  Permalink  
Comments
Dave Kreskowiak at 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 at 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 at 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
0 DamithSL 375
1 Sergey Alexandrovich Kryukov 217
2 OriginalGriff 210
3 Peter Leow 135
4 Uma Shankar Patel 80
0 OriginalGriff 7,380
1 DamithSL 5,359
2 Sergey Alexandrovich Kryukov 4,944
3 Maciej Los 4,906
4 Kornfeld Eliyahu Peter 4,514


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 14 Nov 2012
Copyright © CodeProject, 1999-2014
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