To be able to update a table, you must define a primary key for the table.
Visual Basic with ADO cannot handle big integers. This means
that some queries like
PROCESSLIST do not work properly. The fix is to
OPTION=16384 in the ODBC connect
string or to select the
Change BIGINT columns to
INT option in the Connector/ODBC connect screen.
You may also want to select the