Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page