Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
1  
@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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.