G
GeorgeMar
I have a procedure that updates a table using recordsets
in DAO. The table being updated is part of a query of two
related tables.
This procedure has been working fine for the last 6
months. All of a sudden, I now get the error message
3027, Cannot update. Database or object is read only.
1. How can this happen?
2. I notice that when updating queries with related
tables, sometimes it works and sometimes I get the
abovementioned error. How can that type of query be
updated each and every time?
many thanks
george
in DAO. The table being updated is part of a query of two
related tables.
This procedure has been working fine for the last 6
months. All of a sudden, I now get the error message
3027, Cannot update. Database or object is read only.
1. How can this happen?
2. I notice that when updating queries with related
tables, sometimes it works and sometimes I get the
abovementioned error. How can that type of query be
updated each and every time?
many thanks
george