Hi

I have a strange problem with JDBC and Access.
Im trying to create a table and insert values into it,
but i'm getting an error saying it doesn't like the syntax, and is "expected
1".

for example:

s.execute("create table tblTest(id text, description memo)");
s.execute("insert into tblTest values(123,123)"); //works fine
s.execute("insert into tblTest values(AB123,123)"); //does not work

even tried:
s.execute("insert into tblTest values("AB123",123)"); // still does not work

please help on this strange problem.

Cheers
Sharp tool