How to do a MS Access Update query for a table in external database

[Ed1138]

Hi,


Im trying to perform an update query on a table that its on a separate database, so far i have this SQL:

UPDATE [F:\QA_Daily_YTD_Report_Export.accdb].[YTD-Daily_Report] AS EXT_DB
SET EXT_DB.Category1 = "1"
WHERE (EXT_DB.Category1 = "status1");

When i run this it returns an "invalid operation" error.

Any idea what im doing wrong?

[June7]

Would be easy if you set a link to the table.

I have run DELETE and INSERT on table in another database, not sure of syntax for UPDATE, if it's even possible. Can't find anything.

[Ed1138]

Thanks for the advice, I ended up using VBA:

Dim SQL As String
Dim db_external As Database
Set db_external = OpenDatabase(CurrentProject.Path & "\QA_Daily_YTD_Report_Export.accdb")
SQL = "UPDATE [YTD-Daily_Report]" & Chr(13) & _
 "SET [YTD-Daily_Report].Category1 = '" & New_value & "'" & Chr(13) & _
 "WHERE ([YTD-Daily_Report].Category1= '" & Look_up_value & "');"
db_external.Execute SQL