S
Sam H
Hi all,
I am trying to append the results of a query to a table.
However using an append query does not work due to a known
MS Access 2000 problem preventing append queries from
working if the destination table has a Memo field or a one-
to-many relationship. Details of this problem are on the
following website:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;296389
My question is...is there any other way that I can append
the query results to the end of my table. I am trying to
have a process whereby every week the results of my query
(three fields) can append to their corresponding fields in
the table. Currently I get "key violation" error. I
checked to see if the primary keys were being repeated and
also removed all relationships to the destination table
but neither work.
Thanks,
Sam
I am trying to append the results of a query to a table.
However using an append query does not work due to a known
MS Access 2000 problem preventing append queries from
working if the destination table has a Memo field or a one-
to-many relationship. Details of this problem are on the
following website:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;296389
My question is...is there any other way that I can append
the query results to the end of my table. I am trying to
have a process whereby every week the results of my query
(three fields) can append to their corresponding fields in
the table. Currently I get "key violation" error. I
checked to see if the primary keys were being repeated and
also removed all relationships to the destination table
but neither work.
Thanks,
Sam