Access 2007 problem

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?
chughes43Asked:
Who is Participating?
 
macarrillo1Connect With a Mentor Commented:
Yes.
First create a new database.
Then from the New database, import everything over from the old database.
0
 
macarrillo1Commented:
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.
0
 
chughes43Author 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
0
 
macarrillo1Commented:
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.
0
All Courses

From novice to tech pro — start learning today.