|
|
|
|
|
| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Problem add a record to a db |
|
From: |
Aaron |
|
Date: |
4/27/2001 3:30:04 PM |
|
IP: |
64.208.230.101 |
Something really strange is going on when I try to add a record to a specific table in an access db. I receive the following error:
Error Number: -2147217900
Error Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
File Name: /schedule/Add_Fill2Script.asp
Line Number: 5
I am trying to pass 1 value to the table. Here is my db Update Code:
<!--#include file="ServiceEval2.inc" -->
<%
dim rsEval
set rsEval = Server.CreateObject("ADODB.Recordset")
rsEval.Open "TBL_Locations-Filled", db2, adOpenForwardOnly, adLockOptimistic, adCmdTable
rsEval.AddNew
rsEval("SchedID") = Request.Form("SchedID")
rsEval.Update
rsEval.Close
Response.Redirect "Sched_Action.asp"
%>
My connection object is in the .inc.
Any help would greatly be appreciated
Aaron Custer |
Follow Up - Re: Problem add a record to a db - maria 4/29/2001 1:49:22 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
