I have an Access 2003 database. When I click on a pivot table, I get this message
MS Access There isn't enough memory to complete the Automation object operation on the worksheet object.
But this particular link's explanation doesn't really go into fixing the problem in general, like fixing the pivot tables and getting things all nicely back together in the original Access database. That's why I am also interested in converting the database to 2010 format if that is possible.
Are there instructions (I cannot currently find them and would very much appreciate a link) on dealing with this problem in a nice stepwise fashion?