?
Solved

Connecting 3 memo-fields in query produces weird (chinese?) characters instead of field values

Posted on 2003-11-01
10
Medium Priority
?
503 Views
Last Modified: 2008-03-10
hi,
I just updated yesterday from Access 2000 to Access XP. Everything seemed to work fine, I´ve been working all day in the system, but now I´ve found one strange problem (don´t know if its to do with the update or just coincidence):

I have a table "Products" with the fields "name", "types" and "extrasearchvalues". All 3 fields are Memo fields.
Now in a query I have a field:

Searchfield: ([Products].[Name] & " " & [Types] & " " & [Extrasearchvalues])

the result is that "types" and "extrasearchvalues" are displayed correctly, but instead of "Products.Name" some weird (chinese?) symbols appear.
In the same query, however, I show the "Products.Name" field on its own, and it shows the right values. So there must be something wrong with the joining, but what? I need some help!
0
Comment
Question by:mp1972
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
  • +1
10 Comments
 
LVL 9

Expert Comment

by:rgcole
ID: 9662838
Can you copy and paste an example of the joined memo field where the unusual characters appear?

Robert
0
 

Author Comment

by:mp1972
ID: 9662845
hi,
here are a few examples.


쨀 Samsung SGH-V200 Lithium Ionen

묃 Nokia 5210 6510 7650 8210 8250 8310 8850/8890 8910/8910i Lithium Ionen

脀 Nokia 3100 3310/3330 3410 3510/3510i 6310/6310i 6510 6610 6650 7210 7250/7250i 8310 9210/9210i

贇 Nokia 5210 8210 8250


I´ve just found another weird thing. I made a backup of the database this morning, since then I´ve not really changed anything, just deleted lots of records from one table. But in the backup from this morning the query works. So it can´t have anything to do with the Office XP update...
0
 

Author Comment

by:mp1972
ID: 9662847
(in my query chinese letters appear, the system here seems to have converted them to "쨀" etc...)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Expert Comment

by:rgcole
ID: 9662852
What are the correct 'names'?

쨀 Samsung SGH-V200 Lithium Ionen
I assume that the errant info goes from the ampersand '&' to the block that preceeds Samsung.

What should this value be?

Robert
0
 

Author Comment

by:mp1972
ID: 9662861
the value should be

"Li-Ion Akku ca.1000mAh "

I´ve just tried something else - I copied back the table from which I deleted about 10000 records today, and it works. So obviously something in this table (which is connected with the "Products" table) has gone wrong. Any idea what could have happened??
0
 
LVL 9

Expert Comment

by:svenkarlsen
ID: 9662915
Have you tried doing a compress/repair on the Db ? That often takes care of such.
0
 

Author Comment

by:mp1972
ID: 9662963
yes I've tried "compact and repair", it doesn't help. I've now copied the original table back - it worked - then deleted 10 records - it still worked - then re-deleted the 10000 records and the problem is there again. Something happens when I mass-delete in this table...
0
 
LVL 9

Accepted Solution

by:
svenkarlsen earned 375 total points
ID: 9663094
Did you comp/repair BEFORE the deletion?

Anyhow, it still sounds to me like a question of database corruption, - especially considering that you are making extended use of memo-fields (in my experience, they are actually not the strongest feature of Access).


- this is just an attempt at a work-around:

you could try to extract anything but the records you want to delete to a temp table, and then see if that table gives you same result.
0
 

Author Comment

by:mp1972
ID: 9663105
hi,
thanks for you help, but I've found the problem (although I don't know what causes it)... its a relationshop problem. When I deleted the relationship between the "products" table, and the table with the records I deleted, the problem disappeared. So I've now modified the query using a different sort of relationship and it works.

No idea what happened, anyway thanks to all for your help!
0
 

Expert Comment

by:skennedy10
ID: 12138110
I'm having this same problem.  My user has sent the database back with Chinese characters.  Apparently it also created a new record "0".  

I have not had a chance to look at it, but starting Monday, that is my prime concern.  

Anyone have a "fix"?
Susan
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question