This is how I thought it was done but everytime I try this I get an error.

VB Code:
  1. For Each FoundMatch As System.Text.RegularExpressions.Match In Mymatches

  2.             Dim table8 As String = FoundMatch.Value

  3.             MsgBox(table8)

  4.             conn.Execute("CREATE TABLE " & table8 & "(file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, file_size MEDIUMINT UNSIGNED NOT NULL, file MEDIUMBLOB NOT NULL)")

  5.  
  6.  
  7.         Next

The error is...

Code:
System.Runtime.InteropServices.COMException was unhandled
  ErrorCode=-2147217900
  Message="[MySQL][ODBC 3.51 Driver][mysqld-5.0.18-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '30(file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARC' at line 1"
  Source="Microsoft OLE DB Provider for ODBC Drivers"