MS Access reserved error (-7713);

[netsmurph]

I have an access database which i have set up linked tables for the front end.

I have a query that is appending to a table the records from a large union query.

This part of the procedure worked fine, but now using linked tables it comes up with the following error:

Reserved error (-7713); there is no message for this error.

The vba code I am running if from is below, although I have tried creating a query and the same error is thrown.

DoCmd.RunSQL ("INSERT INTO LINK_ME SELECT TEMP_UNION.* " & _
"FROM TEMP_UNION;")