To whom it may concern,

I am trying to create page that updates a distinctive row in a table in Access database.

I am getting the following error message when I attempt to run my script:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression '1141 Snyder Rd. G-16'.

/woodlynde/update/update.asp, line 24

The '1141 Snyder Rd. G-16' is data from the Access database.


Here is the script below, can anyone help me? Matthew Gallagher

<html>

<head>
<title></title>
</head>

<body>
<%
set conntemp=server.createobject(&#34;adodb.connection &#34
conntemp.open &#34;arc.Woodlynde&#34;,&#34;&#34;,&#34;&#34;
qs=&#34;Update Table1 &#34;
qs=qs & &#34;set Class = &#39;&#34; & request.querystring(&#34;Class&#34 & &#34;&#39;, &#34;
qs=qs & &#34;FirstName =&#34; & request.querystring(&#34;FirstName&#34 & &#34;, &#34;
qs=qs & &#34;LastName =&#34; & request.querystring(&#34;LastName&#34 & &#34;, &#34;
qs=qs & &#34;MaidenName =&#34; & request.querystring(&#34;MaidenName&#34 & &#34;, &#34;
qs=qs & &#34;Address =&#34; & request.querystring(&#34;Address&#34 & &#34;, &#34;
qs=qs & &#34;Town =&#34; & request.querystring(&#34;Town&#34 & &#34;, &#34;
qs=qs & &#34;State =&#34; & request.querystring(&#34;State&#34 & &#34;, &#34;
qs=qs & &#34;PostCode =&#34; & request.querystring(&#34;PostCode&#34 & &#34;, &#34;
qs=qs & &#34;HomePhone =&#34; & request.querystring(&#34;HomePhone&#34 & &#34;, &#34;
qs=qs & &#34;WorkPhone =&#34; & request.querystring(&#34;WorkPhone&#34 & &#34;, &#34;
qs=qs & &#34;Email =&#34; & request.querystring(&#34;Email&#34 & &#34;&#39; &#34;
qs=qs & &#34;where id = &#34; & request.querystring(&#34;ID&#34 & &#34;;&#34;
set rstemp=conntemp.execute(qs)
conntemp.close
%>

<h3>Record Updated</h3>

<p><a href=&#34;../Default.htm&#34;>Return to Main Page</a> </p>
</body>
</html>



Thanks a lot!!!!