Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #13607
| From | Neil <neil@myplaceofwork.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: OLEDB syntax problems |
| Date | 2019-05-02 17:45 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <qafoef$49o$1@dont-email.me> (permalink) |
| References | <qaesto$hd6$1@dont-email.me> <51f838c5-8818-481a-b22f-e7f0c24abf11@googlegroups.com> |
On 5/2/2019 3:33 PM, Ron Paii wrote:
> On Thursday, May 2, 2019 at 8:56:12 AM UTC-5, Neil wrote:
>> 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
>
> is LogIn expecting a date?
>
No.
> ?isdate('2019/5/11') fails with Expected: expression
> ?isdate("2019/5/11") returns true
> ?isdate(#2019/5/11#) returns true
>
> Newer version of Access are pickier on data type.
>
> PS:
> Have your considered using named and typed parameters? The tend to move the data errors into your code where they are easier to trap.
>
All of the values entered into the database are parameterized. I'm
primarily puzzled by the syntax failures of the ACE.OLEDB drivers vs.
the older Access drivers.
--
best regards,
Neil
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll 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