Insert New Item Won't Insert On Server

  • Thread starter Thread starter Earl Partridge
  • Start date Start date
E

Earl Partridge

Access 2000, Frontpage 2000, Windows XP Pro
In Frontpage (.asp file) I build an sql statement to insert a new item into
my table. I get a syntax error. I capture the code, cut & paste it into an
Access query on my local machine and it works perfectly.
In FP/.asp I have even built a test page with the sql hardcoded and it
still gives that syntax error.
Using the same FP and building another sql statement, I have been able
to successfully insert a new item into a different table in the same
database.
Where should I start looking??
Earl
 
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
 
Perhaps Frontpage and Access are using the same "flavor" of SQL...

Have you checked at Google.com for this?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I just found the problem. In the table I was Inserting into, one of the
fields was named "Password". Apparently that is a reserved word.
I changed the field name to "PW" and it works fine. There must be
a list of reserved words around here somewhere.
Earl
 
Back
Top