Access 2007 problem

chughes43
chughes43 used Ask the Experts™
on
I have access database I have been using, and it's been working fine.  All of a sudden today when I try and preview a report it says not enought memory to preform this operation,  I have rebooted computer, no other apps open, did a repair on the database.  I have plenty of memory and I am still having this issue.  Any suggestions?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Michael CarrilloInformation Systems Manager
Top Expert 2012

Commented:
You stated that you have done a compact and repair on the database.  At this point I would make sure that Windows and Office are fully up to date.  You might have a corrupt dll.  Run Windows Update.

The other thing you can do if the above does not fix your problem is to import all your database objects into a new blank(empty) Access database.  There are some Access corruptions that cannot be fixed and the only solution is to move everything into a new Access database.

Author

Commented:
Is there anyway to copy over all the query's and reports to a new database?  That's the problem it has a lot of query's and a report that took a long time to design.

Thanks
Information Systems Manager
Top Expert 2012
Commented:
Yes.
First create a new database.
Then from the New database, import everything over from the old database.
Michael CarrilloInformation Systems Manager
Top Expert 2012

Commented:
Within the  new Database, click the tab External data.
you will see an Icon marked 'Access' with an arrow pointing to a table.
Click this icon.
Enter the path to the old database and follow the prompts.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial