Update columns in a linked table

[creyn]

I am trying to update columns in a linked table in Access. Below is the line of code I am using to try to do this, but I keep getting this error: Run-time error '3616': Updating data in a linked table is not supported by this ISAM

DoCmd.RunSQL "UPDATE Import_Data SET FileName = '" & MyFile & "', [Date] = '" & Date & "' WHERE FileName IS NULL And Date is NULL"

 

[Micron]

Is the linked table a text file (like csv)? If so, you can't update it via a query. You'll have to come up with a work-around, like dumping it into a temp table, then writing back to the csv table after updating the temp.

 

[creyn]

Thanks