Gary Kjos
garykjos at hotmail.com
Fri Jul 23 14:47:15 CDT 2004
It would be at least a little scary to maintain but you could use larger text fields to store groups of your other smaller text fields so that COMBINED_FIELD1 of 255 characters contained the data for logical fields 1-51 (assuming 5 character fields) You could then reference data in form controls by using controls populated by MID([COMBINED_FIELD1],1,5) for the first one MID([COMBINED_FIELD1],6,5) for the second etc. Gary Kjos garykjos at hotmail.com >From: "Dan Waters" <dwaters at usinternet.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Database Advisors" <accessd at databaseadvisors.com> >Subject: FW: [AccessD] Need more than 255 fields! (was - Hit the Wall?) >Date: Fri, 23 Jul 2004 13:22:46 -0500 > >Any other ideas on ways to resolve this issue? > >Thanks! >Dan Waters > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters >Sent: Thursday, July 22, 2004 8:45 PM >To: Database Advisors >Subject: [AccessD] Hit the Wall? > >In an Access app w/FE and BE, I need a table that has about 270 fields. A >single form will be bound to the table. (This is a business process >management application.) If I upsize this to a project (never done this), >I >can have up to 1024 fields in a table. > > > >I tried creating a query to join two smaller tables, but queries are also >limited to 255 columns. > > > >Is there a way around this so I can still use an Access BE? > > > >Thanks! > >Dan Waters > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com