---

I have programmed ASP with MS Access for quite a while but I've never seen
this one before:

-----

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of
SQL statement.

------

Here is my code:

MYSTRING = "INSERT INTO Maal VALUES (spiller_id, lag_id, kamp_id, tid, str)
VALUES (1,1,1,1,1)"

Con.Execute( MYSTRING )

All the fields in the table are "number"s.

Can anyone help me?

Quinn

---

> I have programmed ASP with MS Access for quite a while but I've never
> seen this one before:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at
> end of SQL statement.

> MYSTRING = "INSERT INTO Maal VALUES (spiller_id, lag_id, kamp_id,
> tid, str) VALUES (1,1,1,1,1)"
>
> Con.Execute( MYSTRING )

Maybe you're trying to insert in a table where you should use update
instead??
I had the same problem for a couple af days ago. I made that mistake and got
that error.


--
Mvh
Kasper K
---------------------------------
Find en masse gode svar på de spørgsmål
der oftest stilles i nyhedsgruppen d.e.i.w.s.a
på http://www.asp-faq.dk

---

> Here is my code:
>
> MYSTRING = "INSERT INTO Maal VALUES (spiller_id, lag_id, kamp_id, tid,
str)
> VALUES (1,1,1,1,1)"
>
> Con.Execute( MYSTRING )
>
> All the fields in the table are "number"s.
>
> Can anyone help me?

Maybe it`s where you connect...?
ex.
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; <<= = =

If there is no semicolon it will fail.

- Ras.