|
 |
access_asp thread: Error on INSERT INTO
Message #1 by "John Brashier" <johnbrashier@h...> on Fri, 17 Aug 2001 01:18:46
|
|
I am receiving this error on my asp:
Microsoft JET Database Engine error '80040e14'
The INSERT INTO statement contains the following unknown field name: 'Lot
Number'. Make sure you have typed the name correctly, and try the
operation again.
/scripts/save_form.asp, line 41
Except that the database DOES have that field name.
Any ideas?
-John
Message #2 by "Hans van Domselaar" <Hans.van.Domselaar@i...> on Fri, 17 Aug 2001 14:25:22 +0200
|
|
Put square brackets around the field name eg: [Lot Number]
-----Original Message-----
From: John Brashier [mailto:johnbrashier@h...]
Sent: vrijdag 17 augustus 2001 3:19
To: Access ASP
Subject: [access_asp] Error on INSERT INTO
I am receiving this error on my asp:
Microsoft JET Database Engine error '80040e14'
The INSERT INTO statement contains the following unknown field name:
'Lot
Number'. Make sure you have typed the name correctly, and try the
operation again.
/scripts/save_form.asp, line 41
Except that the database DOES have that field name.
Any ideas?
-John
Message #3 by "John Brashier" <johnbrashier@h...> on Fri, 17 Aug 2001 16:20:21
|
|
Hans,
I'm really sorry, I forgot to mention solutions I've already tried.
I have a list of about 20 field names, many of which have spaces in
the name, (not my doing) and I have been using the brackets. This is
the first field that this does not work for.
John
> Put square brackets around the field name eg: [Lot Number]
>
> -----Original Message-----
> From: John Brashier [mailto:johnbrashier@h...]
> Sent: vrijdag 17 augustus 2001 3:19
> To: Access ASP
> Subject: [access_asp] Error on INSERT INTO
>
>
> I am receiving this error on my asp:
>
> Microsoft JET Database Engine error '80040e14'
>
> The INSERT INTO statement contains the following unknown field name:
> 'Lot
> Number'. Make sure you have typed the name correctly, and try the
> operation again.
>
> /scripts/save_form.asp, line 41
>
> Except that the database DOES have that field name.
>
> Any ideas?
>
> -John
>
>
|
|
|
View Cart
