Memo field turns to gibberish

M

MrDangerous

I have a query based on a table of work order information which includes two
memo fields, COMPLAINT and SERVICE PERFORMED. After I replicated the
database, the query returns what appear to be Japanese characters or squares
with punctuation marks instead of the text in the table's fields. What's the
deal?
 
J

Joseph Meehan

MrDangerous said:
I have a query based on a table of work order information which includes
two
memo fields, COMPLAINT and SERVICE PERFORMED. After I replicated the
database, the query returns what appear to be Japanese characters or
squares
with punctuation marks instead of the text in the table's fields. What's
the
deal?
Click to expand...

Is all the data corrupted or just some records or just some fields.

It is possible that one of the memo fields has become corrupted. If
this is true, the fun part if finding which one and then deleting that
record (you will need to re-enter the information.). If you don't need over
255 characters then it is safer to use a text field for notes than a memo
field. Note: the records that appear to be bad are not always the one(s)
that are corrupted.
 
M

MrDangerous

Only the data in those two fields, and only in the query results. The source
table is fine.
 
J

Joseph Meehan

MrDangerous said:
Only the data in those two fields, and only in the query results. The
source
table is fine.
Click to expand...

If you are combining fields from the table into one field, could that
combined filed be greater than 255 characters?

I'm really reaching there. Frankly I don't know what might be going on.
 
J

John Vinson

I have a query based on a table of work order information which includes two
memo fields, COMPLAINT and SERVICE PERFORMED. After I replicated the
database, the query returns what appear to be Japanese characters or squares
with punctuation marks instead of the text in the table's fields. What's the
deal?
Click to expand...

Please post the SQL of the query. You say downthread that the table
data is fine but the query is farkled - that tells us where to look
anyway, though it's a wierd phenomenon!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
M

MrDangerous

And it only happened after I replicated the database. Before that, it was
fine. I'll try to get the SQL tomorrow.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo Field in Table Truncated in query results and in report 1
corrupted memo field in multi-table query 6
Query in vb.net not returning all characters in access memo field 1
Running Query on memo field - character limit 4
Make Table Query Truncating Memo Field at 255 Characters 2
parse data from memo field to text field 4
Need to Identify Records with Carriage Returns within a Memo Field 6
Problem importing to Memo field 1

Top