Error 3001 - Invalid Argument

[MacroAlan]

My SQL statement worked perfectly for the last 3 weeks, today it blows up with "Invalid Argument".

SELECT DISTINCT CST001_OWH_BCCP_WW_M01.PARTENRL_PART_ID_I AS PART_ID_I INTO BCCP_People FROM CST001_OWH_BCCP_WW_M01 ORDER BY CST001_OWH_BCCP_WW_M01.PARTENRL_PART_ID_I WITH OWNERACCESS OPTION;

Nothing is changed.

Help!!





Alan

 

[Crowley16]

has all the relevant tables remained the same?

--------------------
Procrastinate Now!

 

[MacroAlan]

Yes. So far, all it has done is kill my old table and not let me create the new one.


Alan

 

[MacroAlan]

I just discovered that any query I try to run in this database EXCEPT a simple Select Query gives me this error.

Sounds like a Reference problem or something that got un-registered. [red]Anybody got any ideas?[/red]


Alan