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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Autistic son (UK, Wales) needs advice please 6
Good morning 5
Why was I just banned for no reason? 2
email multiple attachments from a folder that i choose 0
>> getting info from sql server 1
Problem with query causing Access to go to white screen 5
Excel Typed text appears in wrong cell 0
Ground loop isolator causes loss of audio signal 9

Back
Top