Check table Schema

Question

Using ADODB.Connection of type Provider=Microsoft.Jet.OLEDB.4.0
I want to check to be sure database information is correct.

i.e. for each table that should be in the database, i want to check to be sure the table exists, each column that should be in the table is there, and that each column has the correct data type.
Im not sure how to programatically do this, and especially not sure how to do this without comprimising existing data.
if someone can point me to the proper sql commands that would be great. Thanks