Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Data Assist - Too Many Fields Defined

Data Assist - Too Many Fields Defined

Thread began 5/03/2011 1:10 pm by werecat321138 | Last modified 5/04/2011 10:54 am by werecat321138 | 3332 views | 3 replies

5/04/2011 6:55 amJason ByrnesWebAssist

this is a limitation to the microsoft Jet database engine.

The microsoft Jet database engine limits the number of output fields that a query can have to 255 columns. Similar to an access table, a query can have no more than 255 columns.

Note on UPDATE queries:
Note also that as the microsoft Jet database engine iterates through the records in an UPDATE query, it creates a field for the original value and a field for the updated value. When more than 127 fields are selected, it reaches the 255 field limit of a query.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.