Hi,
I am using VB 6.0, ADO 2.0 with MS Access 2000 Database.
in a vb form, i need to fatch data from 3 different tables (ABC.MDB).
it will be a tedious job if i create 3 connections with 3 recordsets.
is it possible to do programming in such a way that we can use multiple recordsets with SAME connection?
firing SQL statments one after the other and building recordsets.
each recordset will contain different no. of records.
if yes, HOW?
waiting for reply,
thnx.
I am using VB 6.0, ADO 2.0 with MS Access 2000 Database.
in a vb form, i need to fatch data from 3 different tables (ABC.MDB).
it will be a tedious job if i create 3 connections with 3 recordsets.
is it possible to do programming in such a way that we can use multiple recordsets with SAME connection?
firing SQL statments one after the other and building recordsets.
each recordset will contain different no. of records.
if yes, HOW?
waiting for reply,
thnx.