Solved

Evt Logs import into MS Access

Posted on 2007-03-26
4
986 Views
Last Modified: 2008-02-01
Hi all, trust you are well.

Question: Does anyone know if there is a way in MS Access, without the use of 3rd party apps, a way to read in the Event logs of a pc (.evt files). I'm writing a small database to be able to query the security log files for specific information.

Thanks
Sean
0
Comment
Question by:SeanNij
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 18798263
This links might help:

http://www.microsoft.com/technet/scriptcenter/guide/sas_log_iwbi.mspx?mfr=true

Maybe set a reference to the Scripting LIbrary ....

also

http://www.softwareshelfdistribution.com/files/productsFeatures.asp?ID=150&page=_features

There has got to be a way

mx
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 18799092

  It's a bunch of API Calls.  Found some code here:

http://www.mvps.org/st-software/VB_Code_LJ.htm

  But your not allowed to distribute the source.  It's also VB6 (should convert easily though).  Either use as is and distribute as an MDE or read through and figure out what API calls are required (just open the class modules in notepad).

JimD
0
 
LVL 1

Author Comment

by:SeanNij
ID: 18805903
Thanks. Between the two i'm managing - well getting there - well almost....

But thanks
0
 
LVL 75
ID: 18805923
Wow ... that was a long shot for me ... and thanks for give JD some points.

If you could, post back what you actually do ... because this is one of those off the wall things - so to speak ... that might be good to know somethime.

mx
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now