I want to find out if two tables are identical (e.g. same fields, same
indexes, etc....). Not the data, but the table structure itself.
Is there a smart way to do that?
Cheers
Nicolaas
Take a look at FMS http://www.fmsinc.com or SSW
http://www.ssw.com.au/SSW/Products/ProdSummaryList.aspx or
http://www.kliksoft.com/
Otherwise, you'll need to loop through every field in every table, comparing
every property.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"windandwaves" <winan...@coldmail.com> wrote in message
news:4296...@clear.net.nz...
Hi Douglas,
thanks for that, those tools are awesome. I am going to write it myself
first and if it does not work I am going to try to get some of those
tools.... (I prefer to know how things work....)
Thanks a lot.
- Nicolaas