Michael Maddison
michael at ddisolutions.com.au
Sun Jul 25 19:09:39 CDT 2004
Dan, We gave them a choice, we limit the # of columns or upgrade to SQL. They chose to limit the # of columns. I'm pretty sure my colleague tried joining multiple tables (1-1) but the query still choked on the 8K limit which makes sense as a query is just a virtual table. Boolean fields are 2 bytes so you should be OK regards Michael M Michael, How did you split the table up and apply limits to the width of the query? Did your form change sources as the users moved from one area to another? Unfortunately, there is no normalization I can do that would make any sense, and wouldn't hurt the app. I didn't know that queries has an 8K limit, but I hope I won't hit that. Most of the fields are short text fields, or yes/no checkboxes. Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Maddison Sent: Friday, July 23, 2004 12:41 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Hit the Wall? No, We hit this same problem and had to split the table up and apply limits to the width of the query. Be careful with the 8K row limit as well, you will likely run out of row space well before 255 columns. Our client insisted they wanted to scroll sideways over 5 years of data, displayed monthly with 6 columns per month. Our prototype had vertical scrolling but no no no we want it like Excel ;-))) cheers Michael M 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com