Hello all, I've got a kludge of a VB6 application that does:

1.) Read a table to get the next batch number . Result is read into a recordset called rsBatch(rsBatch is defined as 'recordset')

2.) Total up all records procesed

3.) Update the recordset from step 1 with the total.

The application failes with 'Object is Read Only' when I do 'rsBatch.Update'.

The original select used to populate the recordset was selecting from a table called 'Batch'. Logic changes required that I create a seperate table for a different set of batch numbers. (ABatch) the query was modified to pull from this new table. The DBA has verified that the table is not read only.

ANy ideas?

please check your connection setting (e.g. connectionstring) in your VB code