Error 3155 (Acc97 with SQL 7 b/e)

Topic

New Reply

Help!

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 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!!!

Thanks,

Jonathon

Reply | Quote