Cannot update. Database or object is read-only [runtime-error '2147217911 (80040e09)]

[wchoi0513]

Hi all,



I am using Microsoft Access VBA to build a cash flow generation tool. Unfortunately, the tool sometimes generate a run-time error '2147217911 (80040e09) after a number of deals are processed. This error is quite random and irregular as the tool does not always stop at a specific deal. Moreover, it only happens when multiple tools are working in parallel.

The underlying logic of this calculation is to open a linked cash flow database called "tbl_CFDetail" in a temporary recordset and keep adding new entry to the recordset in order to project the cash flows. I found that when this error is generated, the table "tbl_CFDetail" was kind of corrupted and was unable to add any new record.

Does anyone have any idea about this issue? What is the possible cause and the possible solution to it? Appreciate if anyone could help. Thank you!
Error message


Error in debug mode


tbl_CFDetail in error condition


tbl_CFDetail in normal condition


Thank you!

[wchoi0513]

Hi all,

I am using Microsoft Access VBA to build a cash flow generation tool. Unfortunately, the tool sometimes generate a run-time error '2147217911 (80040e09) after a number of deals are processed. This error is quite random and irregular as the tool does not always stop at a specific deal. Moreover, it only happens when multiple tools are working in parallel.

The underlying logic of this calculation is to open a linked cash flow database called "tbl_CFDetail" in a temporary recordset and keep adding new entry to the recordset in order to project the cash flows. I found that when this error is generated, the table "tbl_CFDetail" was kind of corrupted and was unable to add any new record.

Does anyone have any idea about this issue? What is the possible cause and the possible solution to it? Appreciate if anyone could help. Thank you!
Error message


Error in debug mode


tbl_CFDetail in error condition


tbl_CFDetail in normal condition


Thank you!

[ranman256]

make sure your rights have not changed on that folder,
if shared db, make sure the db is split,
SOME queries will invoke READ ONLY depending on the joins,
sometimes the lock file, .lccdb, will stay open and invoke read only conditions.

[orange]

I recommend you show readers the vba code involved.

[June7]

Post the entire procedure code. Or provide the db by following instructions at bottom of my post.

[pbaldy]

Duplicate threads merged since both had replies.