View Thread: Microsoft JET Database Engine error '80040e14'

Welcome Guest | Register | Login

Killersites.com Forum

Category: Programming

Forum: ASP - Active Server Pages

Thread: Microsoft JET Database Engine error '80040e14'

Quick Go »

No member browsing this thread

Thread Status: Active
Total posts in this thread: 1

[ ]

Author

This topic has been viewed 2079 times and has 0 replies

anikur
Stranger

Joined: Oct 21, 2008
Post Count: 1
Status: Offline


Microsoft JET Database Engine error '80040e14'

I GET AN ERROR WHILE ACCESSING ADB USING ACCESS

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.

/acmseva/membersignup.asp, line 48

FOLLOWING IS THE CODE

Set ConObject = Server.CreateObject("ADODB.Connection")
ConObject.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.Mappath("acmseva.mdb") & ";"

Dim RsMembers
Set RsMembers=Server.CreateObject("ADODB.RecordSet")

StrSQL = "INSERT INTO Members(UserName, Password, FirstName, LastName, Address, SuiteAppartment, City, State, PostalCode, CellPhone, DayPhone, EvenPhone, Email, UserTypeID, SessionID) VALUES('" & StrUsername & "','" & StrPassword & "','" & StrFName & "','" & StrLName & "','" & StrStreetAddress & "','" & StrSuiteAprt & "','" & StrCity & "','" & StrState & "','" & StrZipCode & "','" & StrCellPhone & "','" & StrDayPhone & "','" & StrEvenPhone & "','" & StrEmail & "'," & 2 & ",'s" & StrSessionID & "')"

RsMembers.CursorType = 2
RsMembers.LockType = 3

Response.Write(StrSQL)
RsMembers.Open StrSQL,ConObject
ConObject.Execute(strSQL)

Anybody, PLEASE HELP ME

[Oct 21, 2008 5:22:33 AM]

[Link]

[ ]

Current timezone is GMT
Mar 20, 2010 8:04:26 PM