Greetings -

I'm using an Access front end to a SQL Server (2000) database. Via several
steps, I create a temp table and manipulate the data in it. I want to update
the backend with this new data but my UPDATE query fails as my temp table is
local and the SQL database doesn't know about it. There are no linked tables
in the FE database.

I have the following (DAO):

Set Db = CurrentDb Set Qdf = Db.CreateQueryDef(TMP_QUERY_NAME)

Qdf.connect = ConnectString()

sqlString = "UPDATE tblRemote " & _ "SET " & _ "tblRemote.Some_Foo =
tblLocal.Foo, " & _ "FROM tblRemote INNER JOIN tblLocal " & _ "ON
tblRemote.Some_ID = tblLocal.Some_ID;"


Qdf.sql = sqlString Qdf.ReturnsRecords = False Qdf.Execute dbFailOnError

Is there any way of doing this without adding a linked table?

Thanks in advance,

chris