ODBC update on a linked table failed :(

[vagg]

Hello Gurus,

I have a system that runs a MSAccess front end with an SQL backend.

one form in my program adds a value to a field in a table in multiple rows as selected by the user.

My program works great on my laptop but when I install it on a server, It is not able to handle many rows - it gives this error -

ODBC - Update on a linked table failed - error code 3157.

Please help me!

Thanks in advance!

 

[nickdel]

What kinda server you putting it on? Could be a permissions problem between that and your SQL server?

Have you tried using the linked table manager to refresh the table links?