Solved

Evt Logs import into MS Access

Posted on 2007-03-26
4
990 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 - Microsoft MVP, Access and Data Platform) 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

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…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

828 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