Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2007 problem

Posted on 2012-03-22
4
Medium Priority
?
246 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 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

916 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