Syntax for updating table in another database from current db.

[muttsylove]

I'm having difficulties creating a sql statement which updates data in another Access database from a current database.

I'm able to do an insert and delete statement just perfectly, but not an Update.

For example, here is a dummy sample (which does not work):

Update tbl_test1 IN '\\C:\Temp\abc.mdb', tbl_test2
set tbl_test1.Name = tbl_test2.Name
Where tbl_test1.ID = tbl_test2.ID

I tried a couple of variations, however, I keep getting an error.
Also, I don't want to create a database link (due to the sheer complexity of my project, which I'll spare you the details..)

Does anyone know how to do this? I searched the forums and came up with zilch! =(.. Help??!

 

[MStef]

Try to do this with LINK TABLE (File, Get External Data, Link Tables).
Than make an Update query on this table, (tbl_test1).