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.
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.