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 資料庫或資料庫專案的資料庫物件
名稱中，使用這些特殊字元。 本文將告訴您，必須避免
使用的特殊字元，以免因為這些特殊字元而造成已知的問題。 | 
