comparing two table of two diff. of the same database

[aquinox]

Hi,

Wonder if anyone might be able to help me here. I have a series of Databases with different names made based on the versioning order.

Recently, there has been a lot of changes happening to our data in the database. If we compare a table from the current version of database with the table from, say, 3 months ago, a lot changes has happen.

Is there a way i can use to trace the changes between tables of two different version of the same database?

Not sure if a query can do the job.

Thank you in advance

 

[VRoscioli]

Not really sure what you are trying to find. Maybe you could provide some examples?


-V

 

[aquinox]

Thank you VRoscioli for your response.

Like to compare two tables in Access database to see if there has been any changes happening between the old and the new tables.

I've got a code here (from the internet) but it doesn't work. wonder if you can help me with it. I know that it's for SQL Server but i just want to try it in Access.

SELECT MIN(TableName) as TableName, ID, COL1, COL2, COL3 ...
FROM
(
SELECT 'Projects_Old A' as TableName, A.ID, A.COL1, A.COL2, A.COL3, ...
FROM A
UNION ALL
SELECT 'Projects_New B' as TableName, B.ID, B.COL1, B.COl2, B.COL3, ...
FROM B
) tmp
GROUP BY ID, COL1, COL2, COL3 ...
HAVING COUNT(*) = 1
ORDER BY ID

The error said that microsoft jet database engine cannot find the input table or query 'A'. make sure it exists & that its name is spelled correctly.

I thought A was there as an alias for Projects_Old. How should i put it in the Access environment?

Thank you in advance