Tables and Field merger

[joeKra]

Hi,
i would like to know if someone can guide me or there is some tool to get a list of table and field differences when comparing 2 databases

thanks,

 

[Pat Hartman]

www.fmsinc.com Has a number of useful tools including a compare utility.

 

[way2bord]

Alternatively, you can run a quick VBA script-loop checking currentdb.tabledefs.

Pseudocode:
chktbl = table to check
chkfld = field in chktbl to check

For each table
for each field in table
does field = chktbl.chkfld
- do stuff
next
next

 

[Television]

Alternatively, you can run a quick VBA script-loop checking currentdb.tabledefs.

Pseudocode:
chktbl = table to check
chkfld = field in chktbl to check

For each table
for each field in table
does field = chktbl.chkfld
- do stuff
next
next

I have similar problem. Could you give sample of actual code?
Thank you!

 

[jdraw]

Bob Larson has a utility, but his site seems to down???
Bob is a frequent poster here, you may be able to send him a PM and get a copy of his code.

Note: Site seems to be available now June 13, 2013


Database merge analysis tool

http://www.btabdevelopment.com/ts/freetools