Insert New Item Won't Insert On Server

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
 
E

Earl Partridge

Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
 
J

Jeff Boyce

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
 
E

Earl Partridge

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Syntax error on SQL INSERT 5
Execute SQL 1
INSERT date into Access table 4
SQL Insert Into command, Two Values for a SINGLE column 4
Insert empty numeric value 3
VBA: Insert Into-Statement for linked Tables 10
SQL INSERT Statement in MS Access 2
Simple Insert statement 4

Top