visualbasic @ win2000 Network

Posted on 2003-03-04
Medium Priority
Last Modified: 2013-11-25
hi ,

i have win2000 network , and i'm the Admin .

My database file (.mdb) is in a network dir ,

if i prevent users from having access to Database Dir

their vb program that run in their workstations will fail to connect to Database ,

while if i let them have it they will be able to reach the mdb file and other important files in this dir manually ( By Windows Explorer for example ) which i want to prevent.

so the Question is how can i make the access to dbase Dir

is just throught the visualBasic Program

and not manually

whether By code or By assigning Rights.

Thanks in advance


Question by:innerjoin
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 17

Accepted Solution

inthedark earned 200 total points
ID: 8069855
Righ click on the folder name.  Select the security tab.  On the "List Folder Contents" line click the box in the "Deny" column.

This will stop explorer from getting at the file.

For a more advanced solution (which I don't think you need unless you are working in a high security operation):

However somebody could write a script to update the file if they knew how.  This would not be a normal employee but a hacker.  You can stop this by allowing your VB program to run an EXE as another user.  In order to do this the user profile "act as part of operating system" token must be set. Or the "Allow elevation or rights" token must be set.  In this way the user rights can be elevated before the task is created.  But a dedicated hacker could also create some software which could also access the file.  For a total defense solution you need to use (com+) DCOM component running on the server.  The DCOM component is set to "run as" a specifed user.  So in your code you use the CreateObject with the server name parameter.  There are some remote component deployment issues so you may need to buy the Enterprise Edition ot VB or do a lot of remote component deployment reasearch.  You will then need to change all of your application code to talk to the MDB via the server based DLL.  If you do this you will be surpised to find that the application runs way faster than direct access to the MDB.

Go for the easy option!

Author Comment

ID: 8072083
Thanks a lot ,,,

i'll try that .

beside my system is not meant to be of tight security .

it is enough for me to stop users Windows Explorer from

accessing my network Database Folder

and make their only way of access is through their Vb application at their workstations.
LVL 49

Expert Comment

ID: 9046892
Hi innerjoin,
It appears that you have forgotten to close this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept inthedark's comment(s) as an answer.

innerjoin, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept THIS comment as an answer.
DanRollins -- EE database cleanup volunteer

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

762 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