Access data Macro error - 20335 alias represents a readonly record

Question

I am trying to create a Data Macro to update values in a table after changes to data in ANOTHER table

(I have read lots of hints and tutorials about updating in the same table and the "before update" but it's not my case I believe)

I need to update quantities "in stock" in a warehouse table when new orders are addes, modified or deleted.

I am following tis tutorial:

http://zahidbi.com/2011/09/21/update-another-table-using-data-macro-in-ms-access-2010/

but I always have the same error about a redonly record...

why?

Answer 1

I need to update quantities "in stock" in a warehouse table when new orders are addes, modified or deleted.

Well, the first problem here is that you have a design flaw in your database. Stock on Hand should NOT be stored, but calculated. It is calculated in a query that adds and subtracts the quantities of your transactions.

So you should not be using a Data macro to do this.

Second, Is this a web app? Data macros are not as flexible as VBA. But without understanding your structure and seeing the macro its hard to advise.