Double Entry Validation

[Snak]

I have been given a task:
Two copies of the same database have been filled in in different locations. The database has 55 tables. I have been asked to compare each table to report on differences.

It occurred to me that a program that would take two paths to identically structured .mdb files as arguments could be constructed. The program would then compare each table in the file(s) and generate the required report. This would then work for any Access database pair.

I can use most of Access 2000 features, but VB is not one of them.

Any suggestions?

 

[KevinM]

The database has 55 tables.

Why so many tables?

 

[Snak]

Don't ask
It's actually a whole raft of responses to questionnaires and, had I been building it from scratch, I'd have found a much better solution.

But, I'm stuck with it. Hopefully if I can find a way of doing this for an unspecified pair of databases, it should not matter how many tables there are. The key would be in getting the program to interrogate the .mdb file(s) to get a number of tables (and their names, or at least, an indexible link to them).

 

[Snak]

Can anyone tell me how I can use a query to get a list of the tables in a database?

 

[KevinM]

Create a new query and paste this in SQL view....

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys*" And (MSysObjects.Name) Not Like "~sq*") AND ((MSysObjects.Type)=1 Or (MSysObjects.Type)=6))
ORDER BY MSysObjects.Name DESC;

 

[Pat Hartman]

Here's a list of all the objects that I have been able to define:

Type Description
-32768 Forms
-32766 Macros
-32764 Reports
-32761 Code Modules
-32758 Admin
-32757 AccessLayout or SummaryInfo
1 Local Access Tables
2 MSysDb?
3 system stuff
4 Attached ODBC Tables
5 Queries
6 Attached Access Tables