Append Query Error "Duplicate Output Destination"

[billkill]

Hello,
I have inherited a large, complex database.
It worked okay until our server went down.
Now that it is on a new server, I had to change the file paths for the
tables (done)
And change the path in the append query (done)
I am down to the last problem.
When I run the append query I get this error: "Duplicate Output Destination
'Date'."
Any ideas?

 

[John W. Vinson]

Hello,
I have inherited a large, complex database.
It worked okay until our server went down.
Now that it is on a new server, I had to change the file paths for the
tables (done)
And change the path in the append query (done)
I am down to the last problem.
When I run the append query I get this error: "Duplicate Output Destination
'Date'."
Any ideas?

Well, using Date as a fieldname is a bad idea anyway; it's a reserved word for
the builtin Date() function.

Do you have a backup?

Could you post the SQL view of the query?

DOES it have duplicate output destination fields, i.e. do you have the field
misnamed Date twice in the query?