Insert into error

[rtlehner]

Why am I suddenly getting a Reserved error (-1524) when doing a simple INSERT INTO COMMAND?

INSERT INTO Table1 SELECT * FROM Table2;

I have a data base which has been running smoothly for years....suddenly, the execution of this INSERT INTO command is failing. Our enterprise may have received some office 365 updates last night...that's the only change which has occurred. Anyone else encounter this sudden error as well?

[CJ_London]

not sure what you mean by 'doing a simple INSERT INTO COMMAND'. Are you executing it by opening a query? using VBA or macro to execute an existing query? or VBA to create the sql string and executing that.

It may be a 365 update that is causing the issue but have you checked the basics - each table has the same number fields in the same order with the same datatypes? and table 1 does not contain an autonumber field?

[ranman256]

do both tables have the exact same fields?