Yep I'm using distributed views.

The only way I can think of to bodge it is by refreshing a local table once a day so the query used to create...

good suggestion and good sp....I've played about with it and its just what I need!!!

But, and there always is a "but"....it falls over...

Questions....

Does the file sit on the same server as the one you have local admin rights to? Or is it on another server or even in another domain?

Is the file...

I think I'll have to go with your suggestion.

Only problem with that is the potential 27+ different variations that I'll have to create....also it doesn't sit well for expansion...

Thanks for your reply......

This means that there is no hard rule for constructing the 'from' clause?

I am trying to create a basic query tool in VBA. Each query will...