We help IT Professionals succeed at work.

Logging/Auditing MS Access network connections.

Zack
Zack asked
on
90 Views
Last Modified: 2019-01-21
Hi EE,

How do you make an audit trail remote connections to an MS Access db 2007 to 2013, is this possible?

The more variables that can be captured the better, the queries being entered will primarily be select queries.

Any assistance is welcome.

Thank you.
Comment
Watch Question

Software & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
If you're looking to capture traffic between your Access Frontends and your Access Backend - i.e. queries, performance data, etc - then you're out of luck except for the stuff that John suggests. Access is a file server database, and doesn't have the audit/logging capabilities like SQL Server.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
How do you make an audit trail remote connections to an MS Access db 2007 to 2013, is this possible?

 Not possible, unless you build a file monitor into the OS where the DB resides.

 You can build something into an app to log at startup, but that won't tell you if someone connects to the DB from outside of the app (say with Excel).

Jim.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Guys,

Cheers for the assistance guys after some research found a terrific link on stackoverflow which gives me exactly what I need:

https://stackoverflow.com/questions/15899930/how-to-see-who-is-using-my-access-database-over-the-network

Thank you.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Zack,

  But that is not what you asked for in your question.  

  Using the JET Show User Roster function only tells you who is in the database at a given point of time.  It's better than reading the .LDB file directly, but is not all that much different.  

  It doesn't "monitor" for connects and disconnects.  You would need to have a task running constantly in order to actually log who touches the database.   And it doesn't do anything beyond that... so it doesn't tell you who ran what queries, forms, reports, etc, which you asked about in your question.

Jim.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Keep in mind that with JET/ACE, the db engine code is executing client side.

There is no central server process as there is with SQL where users can be monitored.  That's why it's just about impossible to do what you asked.

 With JET/ACE, the best you can do is to build something into the app, but that doesn't stop someone from connecting to the DB with something like Excel.

 You would need something on the "server" where the DB resides monitoring who touches the file, and even that would only tell you who and not what.

Jim.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Jim,

Correct but its big a step in the right direction a have the db log connections constantly collating the info and back track from there putting logging triggers where I need via vba. The environment in question is that multiple apps are accessing these databases at when specific events occur we are not aware of an excel reports running ad hoc queries against these databases.  

Cheers for the additional clarifications I appreciate it .

Thank you

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.