How to protect a database to avoid reading it directly

Considering the related question, I want to store SQL Queries in a database, I was thinking on using an access database but I need to avoid that users can open the database with MS Access directly.

Is any way to protect the database from that ?
Is there any other kind of database recommended for described purposes?
dimensionavAsked:
Who is Participating?
 
Kalpesh ChhatralaConnect With a Mentor Software ConsultantCommented:
you can Protect your Access database with Strong Password.

Strong Password Means Alphabet + Digit + Special Character.
0
 
EyalCommented:
I would also encrypt the queries. even in flat files (without access)
0
 
guveraConnect With a Mentor Commented:
Please check the below link.

 http://msdn.microsoft.com/en-us/library/aa200349(v=office.11).aspx

Hope it may helpful to you.

Regards
Guvera
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
CodeCruiserConnect With a Mentor Commented:
If you go the encrypted queries in flat files route, here is an ecryption tutorial

http://www.codeproject.com/KB/security/SimpleEncryption.aspx
0
 
karunamoorthyCommented:
You can protect the folder containing ms-access database file using some folder lock, hide folder etc.
You can give protection in operating system level also if your file system is NTFS. You can protect the computer also using login password.

Hence,
you can protect,
ms-access password protection,
file level,
folder level,
machine level

it depends on the criticality of the information you store.

If possible you can use with pendrive or some portable devices and keep the file with you safely.
Once the machine is accessible, if the person really interested to see the information, there are dozens of softwares available to crack the locked / password protected application/file/folder/machine etc.

Suppose you are protecting your information through logon password machine level. Then a simple bootable cd (like Hiren boot cd) can expose your machine to the person can et the required file/information. Hence machine also needs to be protected physically.

It depends on what level protection you want.


0
 
dimensionavAuthor Commented:
The database is part of an application that will be installed on any machine, that queries will be added, edited or deleted by the application itself, the idea is to avoid access from the user to any query directly to database and/or files.
0
 
karunamoorthyConnect With a Mentor Commented:
In that case, password protect ms-access database is of the right choice.

Step by step instructions to protect access database is dealt here using URL

http://databases.about.com/od/tutorials/ss/passwordprotect.htm

Check out the URL to get details.

0
 
dimensionavAuthor Commented:
I will combine all for all project, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.