关于UPDATE的问题
--------------------编程问答-------------------- Only the ADO Connection object has an errors collection. The observant reader will notice that a lightweight error handler is in effect for the RecordSet.Open examples. In the event of an error opening a RecordSet object, ADO should return the most explicit error from the OLEDB provider. Some common errors that can be encountered with the code above are described below.If you omit (or there is an error in) the DefaultDir parameter in the connect string, you may receive the following error:
ADO Error # -2147467259
Description [Microsoft][ODBC Microsoft Access 97 Driver] '(unknown)'
isn't a valid path. Make sure that the path name is
spelled correctly and that you are connected to the server
on which the file resides.
Source Microsoft OLE DB Provider for ODBC Drivers
If there is an error in the Dbq parameter in the connect string, you may receive the following error:
ADO Error # -2147467259
Description [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find
file '(unknown)'.
Source Microsoft OLE DB Provider for ODBC Drivers
The previously listed errors will also populate the Connection.Errors collection with the following errors:
ADO Error # -2147467259
Description [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
Source Microsoft OLE DB Provider for ODBC Drivers
ADO Error # -2147467259
Description Login Failed
Source Microsoft OLE DB Provider for ODBC Drivers
Note that for each error, the ADO Error number is the same, in this case translating to 0x80004005, which is the generic E_FAIL error message. The underlying Component did not have a specific error number for the condition encountered, but useful information was never-the-less raised to ADO. --------------------编程问答-------------------- 1换种方式试试
sql="update ..set...."
cnn.Execute sql
2 感觉楼主的连ACESS的驱动过低或者连ACESS的驱动有问题,Provider=Microsoft.Jet.OLEDB.4.0
--------------------编程问答-------------------- abc
补充：VB , 基础类
