Compare two access databases, size of tables 
Author Message
 Compare two access databases, size of tables


I'm writing a program to compare two access databases, and the tables within
both of them.  I'm really just interested in the number of records in each
table, and would like to get something like this into a recordset or table.

TableName,    OldDBRecordSize,    NewDBRecordSize
myTable            34                                37
anotherTable        67                                78

I've already set up the framework for this, and have the path's to both
databases.  Is there a quick query to generate this result set though?  I
know I can use ADOX to get the table names, then individually query them for
the sizes, I'm just looking for an easier solution.


Michael Ramey
Smithfield Premium Genetics
385 Hwy 158
Roanoke Rapids, NC 27870

Wed, 14 Dec 2005 00:30:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Comparing Two Access Tables?

2. Linking two Access tables in two databases

3. Compare structures of two Access databases

4. comparing field values from two different access databases

5. Comparing two tables and then updating one table.

6. comparing data in specific fields from two tables ???

7. Two tables, two databases

8. Key field violation when comparing two tables

9. comparing two tables

10. Linking two tables from two diferent databases.

11. Comparing Two Tables

12. Joining two tables from two databases


Powered by phpBB® Forum Software