Database related issue in VB

Question

0.00/5 (No votes)

See more:

Dear all
My name is Sarfaraz. I have actually created a project in vb6 and Ms Access. Now I have created a setup of my project and after i installed it on another computer it works fine but i have an issue i.e the database installed by the set up is open to anyone using that computer.
Anyone can open the tables and delete the records or insert new records from backend (Access tables).
I want a method so that no one can access/see the database and tables.
I Have used security for opening the database i,e after opening database it ask for a pasword. Is this the only method or there is some other method to solve this problem.

Thank you in advance.

Sarfaraz

Posted 16-Sep-12 19:37pm

sarfarazbhat

Add a Solution

2 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)

Trilok Arora · Answer 1 · 2012-09-17T10:48:00

Solution 1

For your issue, setting password is the only way to protect someone from accessing your database.

Through code you can always use DCL statements such as GRANT, DENY on tables.

Posted 17-Sep-12 10:48am

Trilok Arora

Comments

Maciej Los 17-Sep-12 17:02pm

Not necessary... ;) Read my answer.
+5!

Maciej Los · Answer 2 · 2012-09-17T11:13:00

You can use simple trick to deny users to open your database in MS Access and to see the content of database (tables, queries)...
http://www.access-programmers.co.uk/forums/showthread.php?t=51479[^]
But remeber, first hide DB window on startup (Tools->Options menu).

This will not prevent user to see the objects in the database using another database (users can still connect to your database). So, Trilok Arora has right writing: "setting password is the only way to protect someone from accessing your database" ;)