Copying Files for Query purposes

I've got a workbook that needs data from multiple tables within a widely used Access file on our network. The authors "helpfully" put the file in a folder path of "X:\Data Tables 3.0\data"

Because of the dot in 3.0, I can't do a normal Query of the file (KB Article ID: 214377). I'm getting around the limitation by temporarily copying the file to my C: drive and then doing the Query to that location. Thats fine for me, but I want others in my dept. to be use the workbook as well.

Anyone know how to automate the copy of the Access file from within Excel using VB? What about deletion after I'm done with the copy? Doable?

Or is there a different way to obtain the data from the Access file directly without running into the error?

Thanks in advance,
Kestrel

Given the lack of responses, I'm going to assume the answer is No.
Not really suprised, as I could see some security issues in manipulating non-excel files via VBA.

Thanks anyway to those who looked at it.

Thanks snb, I'll give it a shot tonight.