Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recordset is read-only for one opened as appendOnly

Status
Not open for further replies.

PavelGur

Programmer
Sep 21, 2001
75
I have a program that worked all right for a while. I added to the table that is being opened by the program couple of fields. And immediatelly program gives me 1009 error "Recordset is read-only" on AddNew. I had CRecordset::none originaly and had no problem to add new row. I changed it to CRecordset::appendOnly after I've got this error first time and it did not help though it opens w/o any error. It is MS Access DB. I restarted the computer and repaired and compacted DB.
Does anybody have an idea how to fix it?
Thanks, Pavel.
 
I found bunch of problems like this on Internet and CodeGuru. While I was looking I came with solution. I deleted .clw file and opened workspace again rebuilding .clw. Then I ran rebuldall and after this program runs OK.
Pavel.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top