Japanese characters corrupt database

[Gary Schrader via AccessMonster.com]

I have a database I use for training. I copy the database to the local
drive of each studens machine. During training, as we work through a
series of exercises, some of the machines will convert the text in some of
the fields in the database to Japanese characters and corrupt the database.

There is no consistency in when this occurs. It is not specific to any
particular table, form, report, query or module. It is random and does not
occur on every machine, even though each machine has a copy of the same
database.

In some classes, it will occur only once and when the database is replaced
with another copy, there is no corruption. In other cases, it is
persistent and corrupts the new copy, as well.

Has anyone experienced the same thing and if so, do you have a resolution?

--
Message posted via http://www.accessmonster.com

[Tony Toews]

"Gary Schrader via AccessMonster.com" <fo***@AccessMonster.com> wrote:

I have a database I use for training. I copy the database to the local
drive of each studens machine. During training, as we work through a
series of exercises, some of the machines will convert the text in some of
the fields in the database to Japanese characters and corrupt the database.

There is no consistency in when this occurs. It is not specific to any
particular table, form, report, query or module. It is random and does not
occur on every machine, even though each machine has a copy of the same
database.

In some classes, it will occur only once and when the database is replaced
with another copy, there is no corruption. In other cases, it is
persistent and corrupts the new copy, as well.

Has anyone experienced the same thing and if so, do you have a resolution?

And there is no network involved here? That is each student gets thier own copy of
the database?

If so this is very wierd. All the corruptions I'v ever seen involve a network and/or
multiple users in a database.

Hmm, are you using your own MDW for security? Does it have the same name as the MDB?

For more information on corruption including possible causes, determining the
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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