Example Code:
double quotation (") mark does work for MSSQL
but not Access (MDB)
for MSsql : you may save it (") and recall it (")
<%
response.write "<h1>""</h>"
%>
------- Tips for Access MDB ----------
Example code :: solutation for Access MDB
<%
text=request("text")
' ASP server sees "" as "
textReplaced=replace(text,"""","quooooteMark")
' example 7" will become 7quote for your DB to save
' (") must be replaced before save action
'----------
' save in access processd here
'----------
'recall from DB
textReplaced=rs("textReplaced")
text=replace(textReplaced,"quooooteMark","""")
response.write text
%>
---------- attention --------
Microsoft Access (MDB) does not restrict the use of special
characters such as a number sign (#), a period (.),
or a double quotation (") mark in the database object
names or in the database field names. However,
if you do use the special characters, you may
experience unexpected errors.
Microsoft recommends :: !!!
that you do not use the special characters in the database
object names in the Access database or in the database project.
" 在Access MDB 和 MSsql 下的DB储存与呼叫可能会有点差异
Access : " 可在存前更变身, 呼叫后再还身
----------------
Microsoft Access 不会在数据库对象名称或
数据库字段名称中，限制使用特殊字符，例如数字符号
(#)、句号 (.) 或双引号 (")。但是，如果您使用了这
些特殊符号，可能会发生非预期的错误。因此，Microsoft
建议您不要在 Access 数据库或数据库项目的数据库对象
名称中，使用这些特殊字符。 本文将告诉您，必须避免
使用的特殊字符，以免因为这些特殊字符而造成已知的问题。
| 
