I just started working in a new company. They have tons of databases but no structure or standard. I would like to build a tool that will go threw each database and get the list of tables, the items in it and the type. After that I could see all the discreptencies amd fix them. So my question would be if there is functions in vba that will alow me to get all the information on the structure for a given database.
Thank you for any input on the subject.