Odd entries in table of Access database version

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I have noticed a few entries in my database tblTopic table that are showing like this: 

Central Coast (ARF C&#111;ntact Available to H
that should be
Central Coast (ARF Contact Available to H

Another being

Bindi&#039;s puppies
that should be
Bindi's puppies

It seems to only be affecting the letter (o) and the symbol (') so far 

They seem to show up fine on the forum but when someone is subscribed to the topic, the email is sent out with the subject like this

My forum name : Bindi&#039;s puppies.

Is my database corupt? I compact it fairly often.

I only have 27 members and over tghe last 3 - 4 months only have 300 or so posts so it is not being overworked.

I have the ritch text editor turned on also.

My members use IE, Firefox and some are also MAC users. Not sure if this has any bearing but I just thought to mention it.

I hope to keep it an access version to transferability as I am hosting it on one of my servers at home, but if someone else was to take my place it would be just a case of copying the files to their hosting and changing a few configs and it is up and running again.

It isn't impacting my forum too much but I am worried about an impending problem.

Someones input would be appreciated.

Cheers

Justin

Edited by jckruger - 14 July 2006 at 6:12am