Large Query with more than 255 fields

[Danny.McCarthy]

I have 8 tables in Access 2000, 1 Main table (Member Details) then 7
Tables that relate to this table using an ID from table 1. In all
there are 262 fields in the 9 tables.

I want to design a VB front end that has 6 tabs per record and when you
click on the ADO Data Control you go through the records and all 262
fields from the different tables that are related.

Is this best done in Access (Query) or other way. Not forgetting there
are 262 fields.

How do I do this.

[Ed Robichaud]

Even if you uses Oracle, there is a real data structure problem here. The
Social Security system runs with less distinct fields; how did yours get
this bloated? Try running the table analyzer. I can almost predict that it
will find many fields that really should be records -i.e. phone1, phone2,
phone3, etc. when there really should be one just phone field and one
phonetype field.

As you may have already discovered, Access/Jet has a limit of 255 controls
per object. Can't see how you could fit all that on one form, even if you
decide that you want to.
-Ed

<Da************@WallaseySCC.Org.Uk> wrote in message
news:11********************@c13g2000cwb.googlegrou ps.com...

I have 8 tables in Access 2000, 1 Main table (Member Details) then 7
Tables that relate to this table using an ID from table 1. In all
there are 262 fields in the 9 tables.

I want to design a VB front end that has 6 tabs per record and when you
click on the ADO Data Control you go through the records and all 262
fields from the different tables that are related.

Is this best done in Access (Query) or other way. Not forgetting there
are 262 fields.

How do I do this.

[Paradigm]

I would use a seperate form for each table and then insert these into a
tabbed form (as sub forms) using the ID as the link field.
Alex
"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:9n**************@monger.newsread.com...

Even if you uses Oracle, there is a real data structure problem here. The Social Security system runs with less distinct fields; how did yours get
this bloated? Try running the table analyzer. I can almost predict that it will find many fields that really should be records -i.e. phone1, phone2,
phone3, etc. when there really should be one just phone field and one
phonetype field.

As you may have already discovered, Access/Jet has a limit of 255 controls
per object. Can't see how you could fit all that on one form, even if you
decide that you want to.
-Ed

<Da************@WallaseySCC.Org.Uk> wrote in message
news:11********************@c13g2000cwb.googlegrou ps.com...

I have 8 tables in Access 2000, 1 Main table (Member Details) then 7
Tables that relate to this table using an ID from table 1. In all
there are 262 fields in the 9 tables.

I want to design a VB front end that has 6 tabs per record and when you
click on the ADO Data Control you go through the records and all 262
fields from the different tables that are related.

Is this best done in Access (Query) or other way. Not forgetting there
are 262 fields.

How do I do this.