Groups > comp.databases.ms-access > #13603

OLEDB syntax problems

From	Neil <neil@myplaceofwork.com>
Newsgroups	comp.databases.ms-access
Subject	OLEDB syntax problems
Date	2019-05-02 09:56 -0400
Organization	A noiseless patient Spider
Message-ID	<qaesto$hd6$1@dont-email.me> (permalink)

Show all headers | View raw

We recently completed updating our Access database to .accdb format and 
using the ACE.OLEDB driver. Last week, one of our tracking functions 
began to fail with the message:

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

After testing, including checking the Microsoft documentation (the error 
number is useless), the on-line SQL syntax verification that shows the 
syntax to be 100% correct, and other sources, we are still getting the 
error. The current syntax is:

INSERT INTO AdTrack (LogIn, Admin, Action) VALUES ('" & LogVal & "', '" 
& WhoAdm & "', '" & DidWhat & "');

Everything is simple plain text except LogVal, which is a date & time 
compilation that is converted to text. Our own syntax checker that uses 
the same content as the live version returns this result which appears 
to be valid:

INSERT INTO AdTrack (LogIn, Admin, Action) VALUES ('2019/5/1/11', 'John 
Smith', 'Upload of email attachment failed at 11:30:00 AM: ');

Any help and insights are appreciated.
-- 
best regards,

Neil

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-02 09:56 -0400
  Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-02 11:15 -0400
    Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-02 17:38 -0400
  Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-02 12:33 -0700
    Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-02 17:45 -0400
      Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-03 05:25 -0700
        Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-03 08:48 -0400
          Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-03 20:51 -0400
            Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-04 07:05 -0400
              Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-04 15:43 -0400
              Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-04 15:56 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-04 18:57 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-06 13:57 -0400
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-06 14:46 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 08:17 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-07 06:32 -0700
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 10:49 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-07 07:54 -0700
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 11:17 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-07 08:46 -0700
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 12:18 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-07 10:28 -0700
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-07 16:34 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 17:16 -0400
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-08 12:58 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-08 13:20 -0400
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-08 14:24 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-08 15:34 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-09 15:36 -0400
                Re: OLEDB syntax problems Ron Weiner <rw@domain.com> - 2019-05-07 16:49 -0400
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-07 17:18 -0400
                Re: OLEDB syntax problems Ron Paii <ron81pai@gmail.com> - 2019-05-06 12:33 -0700
                Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-06 15:52 -0400
  Re: OLEDB syntax problems FreeToGolfAndSki <genoagroup@gmail.com> - 2019-05-08 06:41 -0700
    Re: OLEDB syntax problems Neil <neil@myplaceofwork.com> - 2019-05-08 13:26 -0400

csiph-web