I know that ASP doesn't like those characters as it interferes with the code. I would do a find and replace in your access db to get rid of them (replace with one of these `) and then try your pages.

Also for future your asp pages should use the find replace function i.e.
<%

sMyString = "they're"
sMyString = Replace(sMyString, "'", "`")

Response.Write sMyString = they`re

%>