Small database created under Access 2007, with various information linked to “Person” records (one record for each resident in the community). Residents offer various volunteer services; each one is tracked in an “Offer” record – using a multi-value field for the person(s) volunteering so that, for example, a husband and wife can volunteer as a unit. This multi-value field is the link to the Person record.
In order to show the offer records for an individual Person, I use a query that links the Person and Offer records using the Person ID to retrieve the offers (Access will not allow a direct ID query to the multi-value field.) and display them in a split form. This method has worked well for three years; the filtered Offer records were displayed and could be edited as needed.
Several weeks ago, we updated to Access 2010. Since that time, the Offer records display as always on the linked form – but if I attempt to update any field, I get a Write Conflict message that another user has updated the record, etc…. and I have found no way to force the updates. From other web inquiries I’ve read, this appears to be a bug in 2010. How can I resolve this problem?
In order to show the offer records for an individual Person, I use a query that links the Person and Offer records using the Person ID to retrieve the offers (Access will not allow a direct ID query to the multi-value field.) and display them in a split form. This method has worked well for three years; the filtered Offer records were displayed and could be edited as needed.
Several weeks ago, we updated to Access 2010. Since that time, the Offer records display as always on the linked form – but if I attempt to update any field, I get a Write Conflict message that another user has updated the record, etc…. and I have found no way to force the updates. From other web inquiries I’ve read, this appears to be a bug in 2010. How can I resolve this problem?
