I have a form that has been modified to collect and store additional data. The form has a subform that is powered by a query. After I made the changes and put them back into production all is fine except that I have found one user that when they try to make changes in the subform the status bar indicates “recordset not updatable” (all other users are fine). I opened the query for this subform and tried to make changes to the data directly in the datasheet view with the same negative affects.I have tried loading the database locally on the problem machine and still have negative results. We are not using workgroups, and I have re-installed Access on this machine. This problem is really holding up production. Does anyone have a suggestion?
