Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2007 problem

Posted on 2012-03-22
4
Medium Priority
?
239 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
This collection of functions covers all the normal rounding methods of just about any numeric value.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

722 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