Update query to a linked Excel table

D

Daniel

I have a db with a linked table to an Excel worksheet. I have several update
queries that are used to update data in the linked Excel worksheet.
Everything works, but I get asked on each update this action will update
data in the table, do you want to procede. I have all the options turned
off in Access to not confirm on action queries, but still I am getting
prompted on every update query.

Is it because of the linked Excel worksheet? Is there a way to turn this
off?

Thanks...Daniel
 
Top