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.
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.
Old KB# 33312
