Memo fields and update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a large update query, but there are a number of fields, that if
I include them, cause the query to crash. There are 13 memo fields in the
record being updated. 7 of these field update fine. The 6 other cause the
crash (any one of them). In both groups of fields, for the test record I'm
using, there are fields with values, and Null fields. Can anyone suggest
what might be causing this odd behavior.

Thanks,

Paul Legler
 
Do you have a table with that many memo fields, or is your query joining
multiple tables, each with its own memo field?

Consider posting the SQL of your query if you'd like folks in the newsgroup
to have more specific information from which to work.

By the way, also consider posting the SQL of your query to the 'queries'
newsgroup -- this one (macros) is dedicated to support for macros.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top