Infopath to Access DB Audit Tracking.

[Rajeev.]

Hi,

I have a app created using Infopath/Access 2007. I am also looking to track
changes to a record made on the infopath form in some manner. The programming
for Infopath is in VBScript.

I am trying to see if I can implement some VBScript code to capture changes
on the form and then update a Table in Access that stores the changes to the
fields.

Any ideas on this is highly appreciated.

Thanks,
Rajeev.

 

[noam.rubinstein]

Rajeev,

You and I may be in similar straits.

I am working on a solution for using xml forms to enter massive
amounts of production
content -- then tracking changes on that content through multiple
layers of revisions.
Sort of like the 'track changes' functionality is MS Word.

If you have any ideas, that would rock...


-N

 

[Clay Fox]

This is tricky to do, both to detect the changes easily and to record them.
I would look at the Database Accelerator at http://www.qdabra.com. It can
store the forms but also give you history and revision tracking like you
want. Each individual version of the form and when it was changed and by whom.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Rajeev.]

Hi Clay,

Thanks for the response. Qdabra cannot be used along with MSAccess right ?
Also would the free version give the Auditing capability.

Thanks,
Rajeev.

 

[Clay Fox]

It works with SQLExpress and there is no audit tracking limitation in the
developer version. It is an option in the admin tool.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com