HELP! HELP! HELP

[Mitchell Thomas]

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,

[Tony Toews]

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

[Mitchell Thomas]

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.

[Tony Toews]

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