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

Reply via email to