Memory problem

Piotr

Hi,
I have huge problem, as Access when executing querry (calculating values
qty * price) shows the message "Not enough memory to remove changes" or
something like this.
How can I check what is wrong ?
Tables are to big ?
Something wrong with database ?
I have no idea as I cant find any error log messages ?

regards
Peter

Nov 13 '05 #1

Subscribe Post Reply

1610

Ed Robichaud

Run "Compact & Repair" (from the Tools-Database Utilities menu) then post
back if you still have the problem. Also try creating a small query just
to do your calculated field, then include that new query in your original
one, and limit your results to the minimum number of fields.
-Ed

"Piotr" <ho***@wp.pl> wrote in message news:cv**********@inews.gazeta.pl...

Hi,
I have huge problem, as Access when executing querry (calculating values
qty * price) shows the message "Not enough memory to remove changes" or
something like this.
How can I check what is wrong ?
Tables are to big ?
Something wrong with database ?
I have no idea as I cant find any error log messages ?

regards
Peter

Nov 13 '05 #2

Piotr

I have tried "Compact & Repair" but it doesnt work unfortunatly.
The querry is only for calculating this two fields
I have separated querry in to 2 different ones but still this same.
The most strange thing is that when I took my database from few days ago
(where there was no problem) this querry returns message as well, what I
dont understand at all.

regards
Peter

U¿ytkownik Ed Robichaud napisa³:

Run "Compact & Repair" (from the Tools-Database Utilities menu) then post
back if you still have the problem. Also try creating a small query just
to do your calculated field, then include that new query in your original
one, and limit your results to the minimum number of fields.
-Ed

"Piotr" <ho***@wp.pl> wrote in message news:cv**********@inews.gazeta.pl...
Hi,
I have huge problem, as Access when executing querry (calculating values
qty * price) shows the message "Not enough memory to remove changes" or
something like this.
How can I check what is wrong ?
Tables are to big ?
Something wrong with database ?
I have no idea as I cant find any error log messages ?

regards
Peter

Nov 13 '05 #3

Ed Robichaud

If your MDB will not the Compact & Repair function to finish successfully
( you don't say what happens, or if there is an error message) then you
could try the "Jet Compact" utility available from Microsoft web sites, or
lastly create a new, blank database, then import all the objects from the
old one, then try running compact & repair. Do a search for Access
corruption and you'll find the same info with more details, and a few other
options.
-Ed

"Piotr" <ho***@wp.pl> wrote in message news:cv**********@inews.gazeta.pl...

I have tried "Compact & Repair" but it doesnt work unfortunatly.
The querry is only for calculating this two fields
I have separated querry in to 2 different ones but still this same.
The most strange thing is that when I took my database from few days ago
(where there was no problem) this querry returns message as well, what I
dont understand at all.

regards
Peter

U¿ytkownik Ed Robichaud napisa³:
Run "Compact & Repair" (from the Tools-Database Utilities menu) then post
back if you still have the problem. Also try creating a small query
just to do your calculated field, then include that new query in your
original one, and limit your results to the minimum number of fields.
-Ed

"Piotr" <ho***@wp.pl> wrote in message
news:cv**********@inews.gazeta.pl...
Hi,
I have huge problem, as Access when executing querry (calculating values
qty * price) shows the message "Not enough memory to remove changes" or
something like this.
How can I check what is wrong ?
Tables are to big ?
Something wrong with database ?
I have no idea as I cant find any error log messages ?

regards
Peter

Nov 13 '05 #4

by: Andreas Suurkuusk | last post by:

Hi, I just noticed your post in the "C# memory problem: no end for our problem?" thread. In the post you implied that I do not how the garbage collector works and that I mislead people. Since...

.NET Framework

MySQL 4.0.14/4.0.15, RedHat9 (smp 2.4.20), memory problem

by: Amadeus | last post by:

Hello Everybody! I have a problem with MySQL servers running RedHat 9 (smp kernel 2.4.20) on Intel and MySQL server 4.0.14 (problem also appears on binary distr 4.0.15 and on 4.0.15 I bilt myself...

MySQL Database

Memory leak

by: John | last post by:

Hi all: When I run my code, I find that the memory that the code uses keeps increasing. I have a PC with 2G RAM running Debian linux. The code consumes 1.5G memory by the time it finishes...

C / C++

MQ memory leak

by: José Joye | last post by:

Hi, I have implemented a Service that is responsible for getting messages from a MS MQ located on a remote machine. I'm getting memory leak from time to time (???). In some situation, it is...

C# / C Sharp

ASPNET 1.1 Memory Issues / Leak or heap problems

by: JCauble | last post by:

We have a large Asp.net application that is currently crashing our production servers. What we are seeing is the aspnet_wp eat up a bunch of memory and then stop unexpectedly. Does not recycle. ...

ASP.NET

Managed WMI memory problem

by: Salvador | last post by:

Hi, I am using WMI to gather information about different computers (using win2K and win 2K3), checking common classes and also WMI load balance. My application runs every 1 minute and reports...

C# / C Sharp

Reducing memory consumption

by: Bruno Barberi Gnecco | last post by:

I'm using PHP to run a CLI application. It's a script run by cron that parses some HTML files (with DOM XML), and I ended up using PHP to integrate with the rest of the code that already runs the...

PHP

Memory Leak/Profiling

by: jeungster | last post by:

Hello, I'm trying to track down a memory issue with a C++ application that I'm working on: In a nutshell, the resident memory usage of my program continues to grow as the program runs. It...

C / C++

Python memory handling

by: frederic.pica | last post by:

Greets, I've some troubles getting my memory freed by python, how can I force it to release the memory ? I've tried del and gc.collect() with no success. Here is a code sample, parsing an XML...

Python

memory leak in the code?

by: George2 | last post by:

Hello everyone, Should I delete memory pointed by pointer a if there is bad_alloc when allocating memory in memory pointed by pointer b? I am not sure whether there will be memory leak if I do...

C / C++

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics