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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Action Query (Append) didn't add records due to key violations. 6
Append query in Access to SQL Server 2
Append Query is not working 1
Query Delete and append 0
Append to SQL Server 3
Append Query question - Is this scenario possible? 1
append query creating new records 4
Invalid Argument - Append Query 1

Top