recordset not updateable

[cinderella]

Hi Everyone,

Hopefully someone can give me a helping hand with this problem, as i am at my wits end..
Basically, i have a 97 DB that contains a form that allows users to update and edit information.This form is based on a query which is based then on 2 tables that have a relationship (timeId as the PK).
Recently, we had upgraded our system to 2007 access, and now the form contains the msg "Recordset not updateable".
I've traced back to see where the problem could lie, but the only issue is that i am able to update the tbl, but not the qry ??

Any suggestions?

Thanks in advance..

 

[Banana]

Are you sure that recordset has the relationship or join esatblished? What about indexes?

 

[burrcm]

Corruption can occur without notice. Take the details of the query and create it again. If you now can update from the query, point the form at this new version and it should now work. If the query works but not the form, recreate the form also.

Chris B