469,592 Members | 2,026 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,592 developers. It's quick & easy.

Single Connection Multiple Recordsets

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.
Jun 12 '06 #1
0 2210

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Fred Zuckerman | last post: by
35 posts views Thread by keerthyragavendran | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.