By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,480 Members | 1,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,480 IT Pros & Developers. It's quick & easy.

Memory problem

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.