A disconnected recordsets used to edit customer invoices
has stopped updating.
some code is...
dim cnn as adodb.connection
dim rs as adodb.recordset
dim pProviderName as string
pProviderName = "Provider=Microsoft.jet.OLEDB.4.0;data source ="
cnn.CursorLocation = adUseClient
cnn.ConnectionString = pProviderName & myDBlocation & myMDBname
rs.open <mySQL stmt>, cnn, adOpenKeyset, adLockBatchOptimistic,
set rs.ActiveConnection = Nothing
There is a lot of code over several forms and finally
at the end of the editing session ....
rs.activeconnection = cnn
It all runs without errors. Checking a sample recordset field shows changes
but the changes are not written to the database table upon the batch update.
Any Ideas where I should look?