Access 2007 to Access 2010 Problem

[evalmedi]

Hi, I've just upgraded to Access 2010 and beginnning to wish I hadn't..



... a database I'd written in 2007 and which worked perfectly is just not fuctioning correctly in 2010... on opening a form I now find that I cannot update the records. In fact I can't even add a new record using this form. I get an error message saying recordset is not updateable.

And, yes I have set up both my C and D partitions, including sub-folders, on my hard-drive as trusted sites....

Help!

Any bright ideas appreciated..... thanks

[RuralGuy]

Open the query directly and see if you can change any of the fields.