Query results in "Property value too large" error

[jj95]

All,

I have a database that contains a lot of different technical information on various pieces of equipment that we maintain. We then assign and track these equipment items as they get assigned to jobs.

These jobs require that various forms be filled out, containing information about the specific job assignment, as well as providing a lot of the technical information for the various pieces of equipment.

I have a query that allows me to, on a specified job number, grab all the necessary info from the different tables. But when I run this query, I get a "Property Value Too Large" error. From what I have read, a recordset can have a max of 255 fields.

Is this something that can be customized? If so, how?

Thanks!

 

[GohDiamond]

I'm not saying that this is the only cause for the error but in my experience:

I have seen this error when one of the datasources is a linked Excel spreadsheet that, for example, contained about 20 columns of real data with headers, but the spreadsheet had been formatted beyond the 20 useable columns all the way to the farthest right column, or when the spreadsheet was data filtered beyond the 20th column of real data.

I repaired the Excel spreadsheet, removing extraneous formatting and filters from columns and rows and the error went away.

Just saying...

Hope this helps
Cheers!
Goh

 

[vbaInet]

I suppose the only way to bypass this is to break the number of fields into two parts.

 

[jj95]

Goh -

That might have been it - when I imported all my tables from various Excel tabs, I did find one that appended a lot of extra blank columns as fields. It appears to be working, but unfortunately I am now chasing down another issue that cropped up and has me stumped (and with how things are going to day, will probably result in my posting another cry for help!)

Thanks!