By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,311 Members | 1,844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,311 IT Pros & Developers. It's quick & easy.

Large Query with more than 255 fields

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.