Is there a way to get a difference report on two Jet (.mdb) databases?

Question

I have code that depends a relatively small MS Jet (created in Access) database. Our source control process is far from all that it could/should be (which is a problem that needs to be solved immediately) and we have ended up with two versions of the same database. The person who edited the "other" version is no longer around to give me hints about what he changed. What is the best way to find the differences of the actual data contained in two versions of a database?

Answer 1

Output all the forms and modules to text files and use a text compare utility.

For example:

Sub ToText()
Dim frm, mdl

For Each frm In CurrentProject.AllForms
    Application.SaveAsText acForm, frm.Name, "c:\docs\" _ 
        & frm.Name & ".txt"

'SO formatting

Next

For Each mdl In CurrentProject.AllModules
    Application.SaveAsText acModule, mdl.Name, "c:\docs\" _
        & mdl.Name & ".txt"

'SO formatting

Next
End Sub

Answer 2

Take a look at this http://www.download.com/StarInix-Database-Compare/3000-10254_4-10614062.html

Answer 3

Ther are tools that can do this like: http://www.fmsinc.com/MicrosoftAccess/DatabaseCompare.html

Or you can look at created / modified dates to see if that gives you a clue (change the database window to show details)

Or you can run the Tools / Analyze / Documenter and look at the object properties.