Bump. I'm interested in the answer to this as well.
Did you experience something similar?
Does the Access query call any VBA functions in modules or external libraries? That stuff will only work when the query itself is called inside Access. If you call the same view with Jet, bad things happen. Maybe you can post the SQL for us?