Posted by Larry Linson on 11/01/77 11:29

"Neil" <nospam@nospam.net> wrote

> The machine name changing isn't an issue,
> since these selections are temporary -- maybe
> a few hours or overnight at the most. They're not
> permanent entities.

How about constructing the T-SQL update Query in code and using it as a
Passthrough Query, or creating a Stored Procedure to which you pass
parameters, or, indeed, just creating a Jet query based on information from
the local table, but that does not Join to the local table -- one of these
approaches might avoid the delays, which are, as you pointed out, due to
using a heterogeneous join.

[Back to original message]