Compare table definitions

G

Guest

Each month we have to create a database that is meant as a refresh from
another database soure. As part of the qa to ensure that the Access database
was created correctly we verify to ensure that the tables within the database
have the same field definitions as the prior deliveries.

I'd like to set it up so that all I wil have to do is link the tables and
compare the structures.

For example I have an Account table. the current month would always be
called Account, and then I would create a link to the previous month's
database and call the previous month's Account table Previous_Account. I
want to compare these two tables STRUCTURE only.

If possible I'd like to create a report that I can launch that simply states
that YES these two table strucutures match. This would give me a quick view
into these tables without having to open up the structures and compare
manually.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bringout comparison of last month's data with this month's 5
Compare 2 Tables 1
Automate changing table in query 1
create new blank database by VBA code 5
Option Compare Database 6
compare 2 tables 2
VBA - retrieve data on last create named range from previous inserted named range 0
List all the Forms and compare to another database 9

Top