Solved

Access 2007 problem

Posted on 2012-03-22
4
233 Views
Last Modified: 2012-04-17
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?
0
Comment
Question by:chughes43
  • 3
4 Comments
 
LVL 9

Expert Comment

by:macarrillo1
ID: 37752613
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
 

Author Comment

by:chughes43
ID: 37752634
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
 
LVL 9

Accepted Solution

by:
macarrillo1 earned 500 total points
ID: 37752672
Yes.
First create a new database.
Then from the New database, import everything over from the old database.
0
 
LVL 9

Expert Comment

by:macarrillo1
ID: 37752699
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

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question