Printable View
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???
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 [email protected] or [email protected] for further clarifications
The Ultimate Solution Providers
Authors
Sriman & Jayaraman
Email : [email protected]
[email protected]
Hand Phone : +(6) 016 2237147