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.
--
Anthony

"Anthony Ching" <(E-Mail Removed)> wrote in message
news:3EBCB2D7-8539-451B-9A1B-(E-Mail Removed)...
>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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

On Tue, 29 Dec 2009 18:51:01 -0800, Anthony Ching
<(E-Mail Removed)> wrote:

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

John W. Vinson [MVP]