I've been looking for a way to do this as well. It was handled much better in ADP, but now we're being forced to convert to accdb because MS no longer supports ADP.
The only solution I"ve found so far, is to actually re-write your Access pass through query on the fly. Seems like a hokie solution, but as long as it works....
The only solution I"ve found so far, is to actually re-write your Access pass through query on the fly. Seems like a hokie solution, but as long as it works....
