ADO - join 4 tables


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO - join 4 tables

  1. #1
    Tracy Guest

    ADO - join 4 tables


    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
    Share on Google+

  2. #2
    Bill Vaughn Guest

    Re: ADO - join 4 tables


    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


    Share on Google+

Similar Threads

  1. Replies: 0
    Last Post: 06-04-2002, 11:13 AM
  2. Replies: 0
    Last Post: 04-02-2002, 03:13 PM
  3. ADO addnew returns the wrong identity with inner join
    By Rob Nicholson in forum VB Classic
    Replies: 0
    Last Post: 03-15-2002, 09:20 AM
  4. Replies: 0
    Last Post: 02-07-2001, 05:31 PM
  5. Creating Access97 Database Tables Using ADO
    By Howard Lee in forum VB Classic
    Replies: 1
    Last Post: 04-04-2000, 04:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center