You are here: irt.org | BBS | Re: MS FrontPage98/Access97 database error [This BBS is closed]
Posted by Dan Ambrose on July 07, 1998 at 23:52:10:
In Reply to: MS FrontPage98/Access97 database error posted by Tricia Newbre on July 07, 1998 at 15:23:51:
: I need some help figuring out an error message I'm getting.
: I'm trying to set up an HTML form which collects information from the user, then posts it to an Access97 database. I've found a fairly useful article on the MS support site which goes through the process step by step, and I followed the procedure exactly (twice, in fact, just to be sure everything was correct.). When I filled out the sample form I had created, I got the following error message:
: Database Error: [Microsoft][ODBC Microsoft Access 97 Driver] The INSERT INTO statement contains the following unknown field name:
: 'FirstName'. Make sure you've typed the name correctly, and try the operation again.
: Can anybody give me a hint as to how to get this working?
: Thanks!
: Tricia Newbre
Im assuming your using ASP?
Make sure the field, 'FirstName' is in the database your inserting
information into. Case-matching. That's what that error usually means.
If you still cant find the problem please put
what put you put for the SQL statement.
your sql statement should look something like this:
Insert into TableName (FirstName) values (Dan) .....etc
thanks, and good luck!
Dan Ambrose
Follow-ups:
You are here: irt.org | BBS | Re: MS FrontPage98/Access97 database error [This BBS is closed]