Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

There is a lot of discussion concerning this message. Here is one link. This link has even more detail.

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?

share|improve this question
up vote 0 down vote accepted

I am not sure whether converting will fix this particular issue or not, but it can't hurt to try. Just make a backup of the .MDB, then open the copy in Access 2010 and Save As the new .ACCDB format. That should do it and you can then see if your problem is resolved.

share|improve this answer
Thanks for the suggestion. It opens with Access 2010, but I have no option to save in the .accdb format. – octopusgrabbus Sep 12 '12 at 15:53
@octopusgrabbus: After you open the DB, isn't there an option under the File menu for Save and Publish? – Karan Sep 12 '12 at 16:02
You can also do the Shrink and Repair option, which automatically upgrades it. – user3463 Sep 12 '12 at 16:23
The default option is to save it in the new format if you use save as of course. You can only change the format if you do save as and look for the drop down box to change the extension. – Ramhound Sep 12 '12 at 17:37
Did, and the option to save in the new format isn't there. Only .mdb offered. – octopusgrabbus Sep 12 '12 at 18:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .