Recordset.Update

[kuvo]

cmd.CommandText =
"Create Table MyTable (col1 double,col2 double)"
....
rs.AddNew
rs.Fields("col1") = 100000
rs.Fields("col2") = 200000

rs.Update
----ERROR : The query is not updateble because
it contains no searchable columns to use as a
hopeful key???

[askus]

This case will only persist in a DAO based connection thru ODBC DSN when u r trying to add a new record the system will generat a error (The object is read only) because the table which u created doesnt contain any primary keys so without any primary kesy u cannot use addnew

please get back to solutionproviders@hotmail.com or solutionproviders@yahoo.com for further clarifications

The Ultimate Solution Providers

Authors

Sriman & Jayaraman

Email : solutionproviders@hotmail.com
solutionproviders@yahoo.com

Hand Phone : +(6) 016 2237147