Comparing databases

[J Guy Davidson]

I need to see what's changed in a database over a period of time. I have a
copy of the database (.mdb) from the morning and a copy of the database now.
How might I see which tables have changed?

Thanks very much.

 

[Alex Dybenko]

Hi,
you can either make a set of queries, if you know what tables/fields can be
changed. Or you can use Total Access Detective from www.fmsinc.com, which
will find all changed objects for you

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[J Guy Davidson]

To clarify - I am working in VBA within Access writing a module to compare
two .MDB files - the one where the module is executing, and an earlier copy
of the database. So far, it looks like I'm going to be using ADODB.Recordset
in some capacity...