I have an .accdb on the network. The .accdb has various objects (queries, tables, forms).
The problem lies in a form which has the following dependency
form <--- table <---- query <---- other tables/queries.
So the form has a table (in table layout), where some column are dropdown/list from a query.
I want to work through the form to edit the table in table layout. Normally, the layout provides a "new record row (*)" in the last row and I can edit that row to insert a new record into the table.
But with no change in form and table settings, about 10% of the time when I open the .accdb, the "new record row" is not there. No amount of closing the application and opening it will show the row. I can edit all the existing records, no problems. Giving up and waiting for a new day, or if lucky, several hours sometimes work.
Question: What can cause the "new record row" to go missing? How to make it show?
EDIT: I found that the table has a table property dialog which has an option "Read Only When Disconnected -- Yes/No". But when I set it to "No", it reverts to "Yes" itself again. Furthermore, I copied the .accdb from the network to the desktop it still has the problem.
This thread talks about a offline/online mode in Access 2010. But I can't seem to google for more information.
Any ideas?