What is causing this --I&#8217

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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
 
no, don't think so, but if you connect to SQL server using ODBC - try to
look and appropriate DSN settings
 
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
 
Back
Top