Update remote table from local table

C

chris.ciotti

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,

chris
 
Top