Prevent direct access to the backend database

Question

0.00/5 (No votes)

See more:

I have this problem, I can create a setup for my app/database but everyone can open the backend file which is an MS Access database. I want it so we can only access the database using the frontend app. Please help me solve this.

Posted 3-Nov-10 1:49am

Neeil

Updated 3-Nov-10 7:07am

Nish Nishant

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

William Winner · Answer 1 · 2010-11-03T06:56:00

you would definitely want to password protect the file. Though, with access, there are plenty of free applications that can query the access file and pull out the password.

The only real secure way to do this is to host the database on a SQL server instance somewhere. You can try encrypting the file, but then you'd have to figure out how you are going to handle if two people are going to try to access the file at the same time. Do you decrypt the file during the entire time the application is running to allow others to access the file and then encrypt it once the user closes the application? What happens if the user kills the program from the Task Manager and now you have a decrypted file?

The point is that Access is not the product to use if you are worried about keeping it completely secure.

Not Active · Answer 2 · 2010-11-03T02:29:00

Solution 1

Either don't use MS Access or password protect the file

Posted 3-Nov-10 2:29am

Not Active

Comments

Neeil 5-Nov-10 11:25am

How can i set a password.??

Nish Nishant · Answer 3 · 2010-11-03T07:05:00

Solution 3

Another alternative is to put your database behind a web-service. That way no one can directly access the database except through the web service.

Posted 3-Nov-10 7:05am