Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Insert New Item Won't Insert On Server

Discussion in 'Information Technology' started by Earl Partridge, Jul 28, 2006.

  1. Earl Partridge

    Earl Partridge
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Earl

    What error?

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP

    "Earl Partridge" <earlpNG@pearnet.com> wrote in message
    news:zRO7g.149$y4.56@newsread2.news.pas.earthlink.net...
    > 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
    >
    >
     
  4. Earl Partridge

    Earl Partridge
    Expand Collapse
    Guest

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



    "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    news:e1AoPyucGHA.4312@TK2MSFTNGP05.phx.gbl...
    > Earl
    >
    > What error?
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
    >
    > "Earl Partridge" <earlpNG@pearnet.com> wrote in message
    > news:zRO7g.149$y4.56@newsread2.news.pas.earthlink.net...
    >> 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
    >>
    >>

    >
    >
     
  5. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    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

    "Earl Partridge" <earlpNG@pearnet.com> wrote in message
    news:SqR7g.1690$u4.1248@newsread1.news.pas.earthlink.net...
    > Microsoft JET Database Engine error '80040e14'
    > Syntax error in INSERT INTO statement.
    >
    >
    >
    > "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    > news:e1AoPyucGHA.4312@TK2MSFTNGP05.phx.gbl...
    >> Earl
    >>
    >> What error?
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP
    >>
    >> "Earl Partridge" <earlpNG@pearnet.com> wrote in message
    >> news:zRO7g.149$y4.56@newsread2.news.pas.earthlink.net...
    >>> 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
    >>>
    >>>

    >>
    >>

    >
    >
     
  6. Earl Partridge

    Earl Partridge
    Expand Collapse
    Guest

    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

    "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    news:%235Tsfr3cGHA.2068@TK2MSFTNGP02.phx.gbl...
    > 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
    >
    > "Earl Partridge" <earlpNG@pearnet.com> wrote in message
    > news:SqR7g.1690$u4.1248@newsread1.news.pas.earthlink.net...
    >> Microsoft JET Database Engine error '80040e14'
    >> Syntax error in INSERT INTO statement.
    >>
    >>
    >>
    >> "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    >> news:e1AoPyucGHA.4312@TK2MSFTNGP05.phx.gbl...
    >>> Earl
    >>>
    >>> What error?
    >>>
    >>> Regards
    >>>
    >>> Jeff Boyce
    >>> Microsoft Office/Access MVP
    >>>
    >>> "Earl Partridge" <earlpNG@pearnet.com> wrote in message
    >>> news:zRO7g.149$y4.56@newsread2.news.pas.earthlink.net...
    >>>> 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
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     

Share This Page