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