Hi
I have a table in ms access that is linked to a file in excel. For
reasons that are complicated to explain, my vba code must change a cell
in the excel file (i do that using a ADODB connection), and then launch
the excel file (i use the runapp macro), which refreshes the sheet
(traditional refresh methods dont work). Then I go back to using the
linked table that has the new data.

My problem is that the above process works most of the time, but
sometimes, it gives me a "File access denied" message when launching
the excel file. I cannot understand why since it works many times, but
then seemingly randomly it fails. The files are all on a personal drive
so nobody else is using it at the same time.

Any help would be greatly appreciated