Glenmore
Guest
|
 Posted:
Thu Nov 03, 2005 5:51 pm Post subject:
Query Access Database Table |
|
|
We need to be able to query an Access (MDB) database using a VB script within
MOM.
We have a 3rd party product in our infrastructure that writes a row to a
table in Access each time an event happens.
There is a requirement to have MOM capture an event each time the row is
updated for auditing purposes.
I have been able to export the table to a .CSV file and parse that file
using the single-line log file provider but this relies on the .CSV file
being manually created and this needs to be done automatically/dynamically.
There is no data provider for Access so a VB script looks like the only way
of doing it - is anyone able to point me in the right direction for some
examples as my VB knowledge is very limited.
Thanks |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in