I did this exact thing not so long ago and I did a script task to check if the file is locked before processing. I used an example I found...

I appreciate everyone's contribution, I have enough information here to get started on something. Will post back the results once available.

I ran a trace while the report was refreshing and I have attached the five queries that ran against the table.

I see that people have suggested possibly adding...

I'm away from the office just now but il run a trace in the morning and confirm exactly what queries are being run.

what do you mean by access...