What is causing this --I&#8217

G

Guest

Hello,

I'm attached to a Sql Server through Access. Every where
there is an appostrophy it is replaced by I&#8217. I'd
appreciate any ideas on what the problem is.

Thanks so much.

David S.
 
A

Alex Dybenko

Try to open this table from SQL Server enterprise manager to see what is
actually there
then check DSN properties you use to connect to sql server - probably you
have some translation there
 
G

Guest

Thanks Alex. I've checked the data directly in Sql
Server and it is correct. Do you think the "Sql Server
Compatible Syntax" in tools/options has anything to do
with it?

David
 
A

Alex Dybenko

no, don't think so, but if you connect to SQL server using ODBC - try to
look and appropriate DSN settings
 
G

Guest

Alex,
I'll do that today. A search on Google for I&#8217 got
all kinds of hits with the same problem with the code
replacing the appostrophy. Is there a hint here?

David
 
Top