Database security

[DrewDog_21]

Hi - I am currently working on an ActiveX control (my first one so I am having a ball with it, let me tell you). The goal of the control is to detect if a database has been accessed by anyone using another program.

I have a macro set in Access that will tell me if someone uses Access to open the database. Also I know that somewhere Access has a Last Accessed property or something similar. My question is, how can I tell if someone has used a program other than Access or the VB program to access the database? And how can I accomplish this same goal if the database is something other than Access, such as Oracle? Ultimately, I want to be able to disable the program and database if someone has illegally accessed the database using something other than the program that I have written for access to the database.

Help!!

Andrew

[Serge]

Check out Microsoft Article on how to detect users in Access database

Download the self-extracting JetUtils.exe. Run it. After exctracting all files, run Msldbusr.exe, this will exctract the msldbusr.dll and a sample VB project. Check out the project, it has exactly what you're asking for.