Insufficient key column for updating or refreshing adult sex dating in elkhorn oregon
Did you include the primary key fields in the query Select? Hi, I am trying to write a simple VB application that will update data stored in multiple tables, through the recordset. -- Brian Bushay (Team B) [email protected] information is appreciated.It appears Access doesn't think you have a primary key.
Both tables have primary, table A has one field primary key, but table B has 4 fields composite key.
I discovered this while converting a CGI/RDO app to ASP/ADO.
The following code will not work with ADO however it will work with RDO 2.0.
Open str SQL, g_obj Conn Scheddat, ad Open Keyset, ad Lock Optimistic If m_obj Rs Scheddat.
EOF Then Update Status = False Else Do While m_obj Rs Scheddat.