Access: Field limit

Oct 1, 2012 at 11:05 AM

Hi all -

I'm trying to update or insert records into a legacy Access table with 154 fields. Apparently, there is a limit of 127 fields for updates with OleDB. Has anyone ever found a way around this, using IQToolkit?

Currently, any update of a table with more than 127 fields throws an OleDbException with the message "Too many fields defined".

Thanks, Phil