> i.e. sql = "Select * FROM TableA;Select * FROM TableB"
As far as I know you can't use the above syntax with JET (I haven't seen it
used in any other ADO provider either).
Perhaps an SQL "JOIN " or "UNION" statement will do what you want, a search
in google should give examples.
Mike Collier BSc (Hons)
ADO Browser for viewing ADO properties & events on your system.