Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chinese conundrum

Status
Not open for further replies.

brendoaccess

Technical User
Mar 28, 2006
27
GB
I administer a DB with several users over a network. Every now and again I get a record that has some fields filled in with Chinese (I think!) characters - like this:

?????

Any ideas how this happens, and how I can stop it?

Many thanks
 
This is likely to be corruption and can be caused by any number of things. For example, is your database split? Do users close down properly? You many be able to get rid of it with a compact / repair.
 
Chinese conundrum; isn't that the hot stuff you put on eggrolls? As Remou said, this is almost assuredly corruption! First off, you absolutley need to back up you db religiously! What corrupts one or two records today could just as easily mess up your entire db tomorrow! There are things that increase the chance of corruption, but pinpointing exactly what's causing a given case of corruption is somewhat nebulous. A multi-user environment is a risk factor, especially so when the front end and backend are on a shared drive, rather than having the backend on a shared drive and a copy of the front end on each user's machine. Users being too lazy to shut down the database properly has also been indicted as a common cause. Sometimes a little snooping and note taking can pinpoint who the culprit is. Allen Browne from down under has a very good paper that discusses corruption, its causes and how to protect against it, located here:


Good Luck

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!
 
How are ya brendoaccess . . .

Have a look here:

Access Database Corruption Repair Guide

Access Corruption

Calvin.gif
See Ya! . . . . . .

Be sure to see FAQ219-2884:
 
Good to hear from you again TheAceMan1.

I'll check out the link.

Many thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top