Eric A. Johnson wrote:
> I'm using ADO style. I have an Access database with four tables that
> I will want to do queries on. I will want to do queries on all four
> tables, at least individually, and possibly at the same time (using
> "INNER JOIN"). My question: Is it better to have four individual
> DataAdapters, one for each table, with the DataSet linking to a
> different one for each query; one single DataAdapter, that would
> connect to all four tables at once; or some kind of combination of
> the two? Any tips? As you can tell, I'm rather a newbie at
> databases.

"Eric A. Johnson" <nothere@dontlookforme.com> wrote in message
news:74H4f.2826$q%.2610@newssvr12.news.prodigy.com...
> I'm using ADO style. I have an Access database with four tables that I
> will want to do queries on. I will want to do queries on all four tables,
> at least individually, and possibly at the same time (using "INNER JOIN").
> My question: Is it better to have four individual DataAdapters, one for
> each table, with the DataSet linking to a different one for each query;
> one single DataAdapter, that would connect to all four tables at once; or
> some kind of combination of the two? Any tips? As you can tell, I'm
> rather a newbie at databases.
>
> Thanks,
> Eric
>

"Leon Mayne [MVP]" <l.rmv.mayne@uea.ac.uk> wrote in message
news:unFd35v0FHA.460@TK2MSFTNGP15.phx.gbl...
> Eric A. Johnson wrote:
>> I'm using ADO style. I have an Access database with four tables that
>> I will want to do queries on. I will want to do queries on all four
>> tables, at least individually, and possibly at the same time (using
>> "INNER JOIN"). My question: Is it better to have four individual
>> DataAdapters, one for each table, with the DataSet linking to a
>> different one for each query; one single DataAdapter, that would
>> connect to all four tables at once; or some kind of combination of
>> the two? Any tips? As you can tell, I'm rather a newbie at
>> databases.
>
> It's best to have just one adapter per query. It doesn't matter how many
> tables you are including in your query, it's the job of the database to
> link them together, not .NET
>