Query error

[quinto via AccessMonster.com]

SELECT [Enter Date] AS Expr1, [manifeststoporder(1)].F23, [manifeststoporder
(1)].F5, [manifeststoporder(1)].F6, [manifeststoporder(1)].F12,
[manifeststoporder(1)].F9, [manifeststoporder(1)].F8 INTO ManifestA
FROM [manifeststoporder(1)];

First I created a table to add the above information from a linked table. I
created a delete query to empty the table and an append query to add new
information and it only works a couple of times and then I get an error
message, so I created a make table query (see above) and that too only works
a couple of times and then I get the same error. I tried to manually delete
the table altogether and I get the same same message,
"You cannot record your changes because a value you entered violates the
setting defined for this table or list"
I would think that if the table is created by the query than it should work
every time.

Quinto