Sorry, I just found a solution (after 4 hours) with:
"ALTER TABLE table_name ADD new_column_name varchar;"
>From: Matt Pacha <[EMAIL PROTECTED]>
>Subject: add a column to a table throught a servlet
>Date: Wed, 24 May 2000 11:00:13 GMT
>
>I tried many SQL statements near from :
>
> String sql = "alter table table_name add (new_column_name text null)";
> insertStatement = connexion.prepareStatement(sql);
> insertStatement.executeUpdate();
>
>in order to insert a new column whereever in my table under MS-Access, but
>I
>always get an SQL Error:
>
>"ModifSE -- Ln 189 -- Wrong request on the table:" java.sql.SQLException:
>[Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
>
>I checked some tutorials, and archives, without success...
>Thanks for your time,
>
>/Matt
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
