The code did not fail.

The procedure the code was attempting failed.

Hi,

Did you tick Script Primary keys etc on the options tab when creating the script?

Do the people here try this stuff first.

I tried it and it sure looked like an error to me.

Select aFrom Table2Where a NOT in (select b from Table2)

[Microsoft][ODBC SQL Server...

In access create a query

SELECT MSysObjects.Name

FROM MSysObjects

WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=4));

Regards

Col

If the data is on a network and the connection is lost or interrupted while accessing, it will often corrupt the database.

Select count(1) from table where date = '01/01/2004'