fields changing language??

[Guest]

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?

 

[Guest]

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!

 

[Guest]

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.

 

[Jeff Boyce]

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

 

[Guest]

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.

 

[Jeff Boyce]

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