has been restored to \\server\data\Company\SQL\
tore due to the local mydatabase.mbd being corrupt. The problem at hand how ever is that the restored DB might not have all the "records" and now this needs to be verified that indeed the restored db and the local on is in fact 1:1 copies and no records are missing.
So that is my problem I need to cross ref mydatbase.mdb"Local"
with mydatbase.mdb "Restored backup"
and then some how perhaps if there are differences merge the differences perhaps to a new db so that the new db and corrupt one will be 1:1 copies
See this link as you do get software but is there nothing freeware out there to do this?
I somehow get the feeling I could do this using innerjoints
TSQL but I haven't done this in year and anyone who can help me resolve this is a legend