FW: [AccessD] Need more than 255 fields! (was - Hit the Wall?)

Dan Waters dwaters at usinternet.com
Fri Jul 23 13:22:46 CDT 2004


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




More information about the AccessD mailing list