Created On:  09 February 2011

Problem:

A particular file in the AcuXDBC database can be accessed without error from MS SQL Server but with MS Access there is an error "Record is too large".

Resolution:

Microsoft Access has a limitation of 255 columns and the file in question has more than that. You may work around that limitation in two ways:

1. Create views in AcuXDBC which are 255 columns or less, and then query those views.

2. Execute queries that return 255 columns or less.