How to protect a database to avoid reading it directly

Posted on 2011-10-09
Last Modified: 2012-08-14
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?
Question by:dimensionav
    LVL 16

    Accepted Solution

    you can Protect your Access database with Strong Password.

    Strong Password Means Alphabet + Digit + Special Character.
    LVL 15

    Expert Comment

    I would also encrypt the queries. even in flat files (without access)
    LVL 8

    Assisted Solution

    Please check the below link.

    Hope it may helpful to you.

    LVL 83

    Assisted Solution

    If you go the encrypted queries in flat files route, here is an ecryption tutorial
    LVL 7

    Expert Comment

    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.

    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.


    Author Comment

    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.
    LVL 7

    Assisted Solution

    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

    Check out the URL to get details.


    Author Closing Comment

    I will combine all for all project, thanks!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now