ADO - join 4 tables

[Tracy]

Hi
Is it possible using ADO to join 4 tables contained in an Access mdb, each
contains about 235 fields (so total would be around 940 fields) each table
has a common primary key field that relates the records as a kind of set
together. I would then display them on a VB6 form with a tab control with
text boxes for each field in the recordset. Is this possible ??

Thanks in advance
Tracy

[Bill Vaughn]

This is not a function of whether or not "ADO" can do it, it's a function
of whether the Jet provider can do it. Yes, I would expect Jet to do this,
but can the Jet provider handle that many columns. I would not be surprised
if there were a 255 column limit. Try it...

bv

"Tracy" <tracy@ak.planet.gen.nz> wrote:
>
>Hi
>Is it possible using ADO to join 4 tables contained in an Access mdb, each
>contains about 235 fields (so total would be around 940 fields) each table
>has a common primary key field that relates the records as a kind of set
>together. I would then display them on a VB6 form with a tab control with
>text boxes for each field in the recordset. Is this possible ??
>
>Thanks in advance
>Tracy