I have an Access front end with backend on SQL Server. The db has worked finr for a while, but no I am getting the following message:

ODBC - INSERT on a linked table <name> failed

I have checked many things:
Manual INSERT with SQL Query Analyser - Worked OK
Checked Indexes (?) - No problem
Relinked tables - no difference
Searched web - no answers

Can anyone help - It is doing my head in!!!