Im trying to create a table in an access database using java. When I
used "CREATE TABLE tblTable (time number)" it works fine. However when
I try "CREATE TABLE tblTable (time number, to_place number)" I get the
following error.
ERROR: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
Syntax error in field definition.
What am I doing wrong? Also, what is the datatype in SQL for number:
Long Integer and Memo.
JDBC and MS Access Anywhere ... I am currently working on a Java project that is directly connected with a MS ... I have already connected the ODBC on my windows XP system ... ODBC in windows and then connect to the Access Database file in the project ... folder...regardless weather the user has setup a ODBC connection to the ... (comp.lang.java.databases)
Re: connecting to databace ... > well i have completed a java course but strange thing is we didnt learn ... Connecting an applet to an Access database is actually difficult. ... server that has a real JDBC driver (including SQL Server,... (comp.lang.java.programmer)
Re: Syntax error with dates ... I think the problem lies with the date format in the input field.... links to an access database.... response to the effect there is a syntax error in the date. ... (microsoft.public.inetserver.asp.db)
Autonumber fields in JDBC ... I'm using Java and JDBC to connect to an Access database....autonumber field is when I add a new record? ... (comp.lang.java.databases)
Autonumber fields in JDBC ... I'm using Java and JDBC to connect to an Access database....autonumber field is when I add a new record? ... (comp.lang.java.programmer)
