Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB
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
Rate this: bad
good
Please Sign up or sign in to vote.

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.
  Permalink  
Comments
losmac at 17-Sep-12 17:02pm
   
Not necessary... ;) Read my answer. +5!
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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" Wink | ;)
  Permalink  

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Shai Vashdi 1,588
1 OriginalGriff 528
2 Manas Bhardwaj 383
3 Damith Weerasinghe 330
4 Tadit Dash 315
0 Sergey Alexandrovich Kryukov 9,575
1 OriginalGriff 6,006
2 Peter Leow 4,500
3 Maciej Los 3,540
4 Abhinav S 3,513


Advertise | Privacy | Mobile
Web03 | 2.8.140415.2 | Last Updated 17 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid