how to find missing records in a table

[anonymowho]

this is what I am trying to do.

I have 2 tables in 2 different databases in 2 different directories.

so my first table is called CUSTOMER in the database PROD and in the directory C:/Production/

my second table is called CUSTOMER in the database TEST and in the directory C:/Tester/

Both tables are exactly the same but the production version has some extra rows and I am trying to find these rows that are missing from the test version

the names of the columns are CustomerID, Phone

So here is what I am doing. I go to the CUSTOMER table in the PROD database and I write this query

select *
from CUSTOMER
where CustomerID not in (select CustomerID from [C:/Tester/TEST.mdb].CUSTOMER)

But it seems like when I run this wuery ACCESS just hangs forever and my CPU starts getting used 100 % and i have to end the ACCESS process from the task bar. Is this query correct. If not what can I do to fix it.

[PEB]

Hi,

It's better to link one of the tables into one of your databses!

So you will have the link to your other databse!

When you have the 2 tables in your databse

Start the Create query widzard and choose find unmatched query

Follow the instructions

and you are ok!

:)