Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Unable to update memo field

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-09-2009
Member
 
Join Date: Aug 2008
Posts: 129
Unable to update memo field
  

I have a memo field that contains several text strings separated by line breaks. When I try to UPDATE a textbox to a memo field in MS-Access 97, I get errors when the text get bigger than +-200 bytes. The 'thing' tells me that a 'parameter' must be limited to 1024.I would like to write a query to add another text string to the end of the field. How do I embed a line feed in the SQL?

Reply With Quote
  #2  
Old 24-09-2009
Member
 
Join Date: Jan 2006
Posts: 211
Re: Unable to update memo field

A data field that holds a variable amount of text. The text may be stored in a companion file, but it is treated as if it were part of the data record. Use the Memo field type to store blocks of data. The Memo field contains a ten-byte reference to the actual contents of the memo. For example, in the dBASE command list name, biography, name is in the data file (DBF file) and biography could be a memo field in the text file.
Reply With Quote
  #3  
Old 24-09-2009
Member
 
Join Date: Feb 2006
Posts: 98
Re: Unable to update memo field

The actual size of memos, however, depends on the amount of data you enter into them. This may shed light on the problem, that somehow, maybe indirectly was linked with Adv HTML. Data from Memo fields of records in a table are stored in a separate file with the same name as the table and an .FPT extension. Memo fields are limited only by the amount of available disk space. I think you can try a utility called Advanced Access Repair an style="background-color:#ff0;">toan> repair your Access MDB file. It works rather well for my corrupt Access MDB files.
Reply With Quote
  #4  
Old 24-09-2009
Member
 
Join Date: Aug 2008
Posts: 129
Re: Unable to update memo field

I guess one can view wrapping brackets around a field as good practice as it tells the parser to recognize it as a field or a parameter and not as a key word. When fields have spaces, the square brackets are required. I appreciate your trying an style="background-color:#ff0;">toan> get something fixed, but san style="background-color:#ff0;">toan>p posting this question in different formats.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Unable to update memo field"
Thread Thread Starter Forum Replies Last Post
How can I update each field within a document at once? Rena Windows Software 5 25-04-2011 06:17 AM
Unable to select creative x-fi in Battle Field 2 Delgado Video Games 4 04-07-2010 02:14 AM
Multi Field value field in Microsoft Access Erubiel Windows Software 3 20-11-2009 12:55 AM
Filename field does not update automatically Dyumani Windows Software 2 06-05-2009 09:10 AM
Unable to embed an OLE object in an Access OLE field Santanio Windows Software 2 05-05-2009 11:56 AM


All times are GMT +5.5. The time now is 02:28 AM.