No not realy, as discribed all of the work was done at the client side and that is indeed Microsoft Access.

I constructed a union query in VBA and it...

Okey i'm getting there allmost.

In access i've made a pass-through query wich runs fine. I have a sub-form that's based on that query and now i get the message:

You...

Great, i think that's what i was looking for. Do i have to put that code in a stored procedure? And if so how do i get it's contents from...