Make table QUERY

[M8KWR]

I have done a make table query, but when i run it is states that:-

"Record is too large"

If its any help it should produce a table with 34529 rows.

Many thanks

 

[dhookom]

Your error message suggests you are attempting to insert too many characters into a single record. There is a maximum of 2000 characters per record excluding memo fields.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[M8KWR]

how would i find out which record that was??

 

[dhookom]

What have you tried? You could begin by limiting the query to about half the records and then try and repeat this to find the problem record(s).
You could also change your query to a select query and add a column to the query:
HowLong:Len([Field1]&[Field2]&[Field3]&...)
Sort the query on this column descending or set the criteria to >=2000.

I assume there is a process that needs to be reviewed. I would consider changing this Make table query to an append query that appends to an existing table with one or more memo fields.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.