fields changing language??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Denise Baker - 30 Mar 2007 17:18 GMT

Our 2003 access database has changed a set of records in our main table to
another language, looks like oriental! This has happened about five or six
times in the past year. The only way to get rid of this is to find out who it
was, delete all other records linked to it and then delete the entire record.
One time we had to delete all relationships to the table, make a new table
and copy all other records to the new table except the affected record. Is
this something that only happens in the 2003 version?

Signature

Denise B.

Reply to this Message

SusanJane sjl - 30 Mar 2007 17:44 GMT

Denise,

I've just had the same problem & it's driving me crazy. I'm wondering if
it's a service pack update issue. I have Access 2003, but my database is in
2000 version.

눭욧㿱 is that the kind of junk you are getting? I sure hope someone can
shed some light on this.

This is a real problem for me because the data resides on people's laptops
that are spread out over about 20 states & I can't repair the data.

SOMEONE, PLEASE HELP!

> Our 2003 access database has changed a set of records in our main table to
> another language, looks like oriental! This has happened about five or six
[quoted text clipped - 3 lines]
> and copy all other records to the new table except the affected record. Is
> this something that only happens in the 2003 version?

Reply to this Message

Denise Baker - 30 Mar 2007 18:44 GMT

I haven't found out what causes this yet, but will keep checking to see if
anyone else has a solution. Hopefully someone will read this that can let us
know what to do to fix this.

Signature

Denise B.

> Denise,
>
[quoted text clipped - 17 lines]
> > and copy all other records to the new table except the affected record. Is
> > this something that only happens in the 2003 version?

Reply to this Message

Jeff Boyce - 30 Mar 2007 20:19 GMT

Denise

One possibility is that this needs prevention, rather than (after-the-fact)
fixing...

Is there a chance this is a shared database? Does each user have his/her
own copy of a "front-end" that is linked to a single "back-end" containing
only tables (i.e., a "split" design)? Is everyone attempting to use the
same single .mdb file, located on a LAN somewhere?

If this is a shared database, being accessed over a LAN, can the network
gurus confirm that there are no faulty/flaky NICs or router/switches or
cabling? Access can be a bit tempermental about poor network plumbing.

Is there a chance that you've been able to identify a particular user for
whom this happens. If so, one possible source of corruption could be if a
person had a record open (e.g., via a form), then "accidentally" powered off
his/her computer without letting Access shut down normally.

If you'll provide more details, it will give the folks here at the newsgroup
more to work on...

Regards

Jeff Boyce
Microsoft Office/Access MVP

> Our 2003 access database has changed a set of records in our main table to
> another language, looks like oriental! This has happened about five or six
[quoted text clipped - 5 lines]
> and copy all other records to the new table except the affected record. Is
> this something that only happens in the 2003 version?

Reply to this Message

Denise Baker - 30 Mar 2007 22:02 GMT

My computer acts as the server, and we have one other person that accesses it
through the network through a shared file for data entry. My knowledge of how
everything in the background actually works is sketchy. Most of the time this
has happened, it has been when the other person is working in the database. I
backup every evening. I'm the one who makes 99% of the forms and reports and
does any changes in the design, and it hasn't happened when I'm doing any of
these.

Signature

Denise B.

> Denise
>
[quoted text clipped - 32 lines]
> > and copy all other records to the new table except the affected record. Is
> > this something that only happens in the 2003 version?

Reply to this Message

Jeff Boyce - 30 Mar 2007 23:45 GMT

Denise

Re-read my previous response. There's a chance there are network issues,
and there's a chance the other user is closing out Access/this application
in a way that causes damage.

Regards

Jeff Boyce
Microsoft Office/Access MVP

> My computer acts as the server, and we have one other person that accesses
> it
[quoted text clipped - 56 lines]
>> > Is
>> > this something that only happens in the 2003 version?

Reply to this Message