473,391 Members | 1,428 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,391 software developers and data experts.

HELP! HELP! HELP

I hope someone out there can solve my mysterious problem. I have
tried everything imaginable, even paid $35 to Microsoft to help me,
but they were not able to figure out this problem: Here is the
problem:

I recently created a new database in Access 2002. I took data from an
access 97 database converted one of the tables to access 2002 and then
imported it into a new table in access 2002. but for some strange
reason, every once in a while the data changes to Japanese characters,
it only happens once in a while, but once it happens that record is
lost. i have tried everything compacting, importing to a new
database, new table...What is causing this strange behavior?


Anyone help would be greatly appreciated....
Mitchell,
Nov 12 '05 #1
3 1683
mi******@boh.com (Mitchell Thomas) wrote:

A more meaningful subject would help a lot with getting meaningful answers. Such as
Japanese characters in record occasionally.
I hope someone out there can solve my mysterious problem. I have
tried everything imaginable, even paid $35 to Microsoft to help me,
but they were not able to figure out this problem:
Eh? I would've thought MS would charge a lot more.

I recently created a new database in Access 2002. I took data from an
access 97 database converted one of the tables to access 2002 and then
imported it into a new table in access 2002. but for some strange
reason, every once in a while the data changes to Japanese characters,
it only happens once in a while, but once it happens that record is
lost. i have tried everything compacting, importing to a new
database, new table...What is causing this strange behavior?


This happens to only one record at a time then? Is it the entire record? Or just
one field in the record? Is it a memo field? When you say Japanese characters do
you mean it's just all kinds of scrambled characters of some sort or what really
looks like Oriental characters? What version of Access? Is this only on new data or
records that have been in the database for a while? Were they just updated?
Assuming you can somehow know this.

What happens when you move to that record? Does Access puke and die? Any strange
messages?

Above said I would suspect some corruption. And that the something is scrambling the
packets going down the wire. Does your building have flaky power? Have you tried
replacing your network hub/switch? Do you have older PCs? I wonder if one of them
has a slightly flaky network card or bad driver.

For other possible causes see the Access Corruption Causes page at my website.
However I rather doubt that OpLocks is causing this problem. It's something
intermittently flaky which can be very hard to track down.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2
Tony Toews <tt****@telusplanet.net> wrote in message news:<0i********************************@4ax.com>. ..
mi******@boh.com (Mitchell Thomas) wrote:

A more meaningful subject would help a lot with getting meaningful answers. Such as
Japanese characters in record occasionally.
I hope someone out there can solve my mysterious problem. I have
tried everything imaginable, even paid $35 to Microsoft to help me,
but they were not able to figure out this problem:


Eh? I would've thought MS would charge a lot more.

I recently created a new database in Access 2002. I took data from an
access 97 database converted one of the tables to access 2002 and then
imported it into a new table in access 2002. but for some strange
reason, every once in a while the data changes to Japanese characters,
it only happens once in a while, but once it happens that record is
lost. i have tried everything compacting, importing to a new
database, new table...What is causing this strange behavior?


This happens to only one record at a time then? Is it the entire record? Or just
one field in the record? Is it a memo field? When you say Japanese characters do
you mean it's just all kinds of scrambled characters of some sort or what really
looks like Oriental characters? What version of Access? Is this only on new data or
records that have been in the database for a while? Were they just updated?
Assuming you can somehow know this.

What happens when you move to that record? Does Access puke and die? Any strange
messages?

Above said I would suspect some corruption. And that the something is scrambling the
packets going down the wire. Does your building have flaky power? Have you tried
replacing your network hub/switch? Do you have older PCs? I wonder if one of them
has a slightly flaky network card or bad driver.

For other possible causes see the Access Corruption Causes page at my website.
However I rather doubt that OpLocks is causing this problem. It's something
intermittently flaky which can be very hard to track down.

Tony

thankx for you repsonse. It only happens to one record at a time, and
it happens to several fields, no consistent pattern when it happens,
it only happens on updates. And yes it is either japanese or chinese
characters, not sure which one, that is what is the most puzzling
thing. running this on access 2002, and it has happened to old
records that were imported from access 97 and new records added in the
access 2002 database. When i move to that record i see the record in
the table, but sometimes it tells me it cannot find the reocrd. It is
a very strange problem. We have not had this problem on any other
access databases, its only this database. Thankx for any help in
advance.
Nov 12 '05 #3
mi******@boh.com (Mitchell Thomas) wrote:
It only happens to one record at a time, and
it happens to several fields, no consistent pattern when it happens,
it only happens on updates. And yes it is either japanese or chinese
characters, not sure which one, that is what is the most puzzling
thing. running this on access 2002, and it has happened to old
records that were imported from access 97 and new records added in the
access 2002 database. When i move to that record i see the record in
the table, but sometimes it tells me it cannot find the reocrd.
Is that the exact text of the error message? Could it be ""Search Key Was Not Found
in Any Record" or

This is really sounding like some network packets got scrambled in transit. IE
corruption.

This could also be one system having a different version of Jet than the others or
not all the Access patches.

What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the tips page at my website for more details including sample
code: Verify Appropriate Jet Service Pack is installed
www.granite.ab.ca\access\verifyjetsp.htm
It is
a very strange problem. We have not had this problem on any other
access databases, its only this database.


Ah, interesting. Is there anything unique about the computers who use that
databases? One which uses only that database and no other?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: clintonG | last post by:
Is there a document that explains the difference between the Visual Studio .NET 2003 Combined Help Collection and the MSDN Library for Visual Studio .NET 2003 or does someone have comments...
0
by: Larry Fix | last post by:
I recently added help to a C# application using the Help.ShowHelp method. My compiled help file gets display so that's good. What's not so good is that the help window always starts out with a...
3
by: Tom marsh | last post by:
I'm finishing an application and want to supply help files. However MS Access's help files, ironically don't contain much help on HELP. What is the best approach? I could easily just provide...
11
by: deko | last post by:
What's the best way to create a help system for Access 2003? Is MS HTML Help Workshop the way to go? I want to put a clickable control on different forms, that, when clicked, will bring up the...
0
by: Junkguy | last post by:
Hi, I need help adding help to my Visual Studio 6 C# form application. In searching around the Microsoft C# documentation for Visual Studio, I cannot seem to discover how to add a menu item to...
0
by: Rich Noons | last post by:
Hi, I'm currently trying to link a help file to an application. Everything is linking correctly to the help topics (on the right hand side of the help file). My problem is that the help contents...
1
by: JJ | last post by:
Ok I have now got to grips with HTML help workshop and created my help files, TOC etc. Now how do I integrate this with my application? I have added an errorprovider to my form and pointed it to...
6
by: WhiteWizard | last post by:
Hello all, I have been tasked with coming up with a system for providing help for our users, and we have some somewhat unique requirements. NO INTERNET. This is a windows application that will...
1
by: TJ WIlson | last post by:
Using Windows XP, my Access 2002 program works, but there are no help files. The help window opens, there is nothing there. I've tried repairing the installation, removing the installation and...
0
by: =?Utf-8?B?cnViZW4=?= | last post by:
Hi developers, Maybe this will sound silly, but I need help placing an icon in a menu when setup is build in .Net through a setup project. Really what I need is indicate the help icon (html help...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.