Updating Excel source whilst in Database using it.

[lynxbci]

Hi,
I have a table in my access db that is a linked table from Excel. To ensure this data is the latest, i want to open the source excel file, refresh it, and then save it.

I have code to do this however, it will not let me update the source data as i am using it in the database.........as a linked table!

Is there a way around this at all ?

 

[DavidAtWork]

I would have thought you could update the source data while your DB is running, how is the Access table being used in your DB
David