[zionshea]

Hello all,

When I run the following SQL statement in MS-Access 2007; application freezes and I only must stop the MS-Access process before I can continue.

select DB.PIN_CODE from DBBBCLADDRESS DB
where DB.PIN_CODE not in (select FL.PIN_CODE from FILEBBCLADDRESS FL);

Please advise what is wrong.

Thanks.

Zion.

[OBP]

Zion, you should try adding error trapping to the VBA code to see if you can get an error message rather than just hanging.
But it looks as if you have a space between DBBBCLADDRESS and DB which may be causing a problem

[Aftab]

How many rows are there in the table FILEBBCLADDRESS and is there an index on the PIN_CODE column?

[zionshea]

Hi Aftab,

There are few tens of thousands in this table and actually I just added an index to that table and the results are somehow better.

I wish the Aftab will shine and smile again on your country...

[Rollin_Again]

Originally Posted by OBP

But it looks as if you have a space between DBBBCLADDRESS and DB which may be causing a problem

Wouldn't the space be required if he was trying to give the table an alias name?

Regards,
Rollin

[OBP]

Rollin, more than likely if it runs a bit.