Database Update

[Anthony Ching]

I have an application where the codings reside in the local machine and the
linked tables reside in a remote server. When I generated the exec on my
development machine everything works fine. However, when the same exec are
generated on other machines, they keep saying run-time error whenever an
update query is executed.

 

[Arvin Meyer [MVP]]

I have an application where the codings reside in the local machine and the
linked tables reside in a remote server. When I generated the exec on my
development machine everything works fine. However, when the same exec are
generated on other machines, they keep saying run-time error whenever an
update query is executed.

There are any number of reasons for runtime errors. Please give us the full
error message, just as you are receiving it. Also it may also help to post
the code and/or SQL statement.

 

[John W. Vinson]

I have an application where the codings reside in the local machine and the
linked tables reside in a remote server. When I generated the exec on my
development machine everything works fine. However, when the same exec are
generated on other machines, they keep saying run-time error whenever an
update query is executed.

In addition to Arvin's points, be sure that you're running the SAME version
and service packs on both machines, or a Runtime generated on the development
machine; and that all the References match on both machines.