PRB: A2K & SQL SERVER : "Record Is Deleted" Append Query Error

I

Irish RangeR

Hi,

I'm having a slight problem and hope someone has a solution or at least, a
reason for it happening.

I have Access 2000 connecting to SQL Server using linked tables. When I run
an APPEND query I get an error message stating "Record Is Deleted". This
happens when I either run the query manually or from code.

I can add records manually to this table, I just can't run the append query.


I would appriciate it if someone could point me in the right direction.



Regards
Keith Burke
Dublin, Ireland.
 
Top