On Tue, 12 Feb 2008 14:31:03 -0800, billkill
>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
>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
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?
John W. Vinson [MVP]