I can't seem to get pass-through queries to accept arguments from text boxes in forms. Additionally, I have many queries and would like one location to change DSN/UID/Password info, rather than having to open up each pass-thru query and modify it. Is it possible to send pass-thru queries to oracle via vba? I would like a simple function/subroutine that accepts an oracle SQL statement as an argument. I do not need it to return rows, as most of these calls will be to run a plsql procedure, but if returning rows is easy to do, then it may be useful... Thanks!
Start Free Trial
