Memory problem

**Ed Robichaud** · Nov 13 '05, 08:39 AM

Re: Memory problem

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" <hokah@wp.pl> wrote in message news:cvii3e$6gg $1@inews.gazeta .pl...[color=blue]
> 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[/color]

**Piotr** · Nov 13 '05, 08:39 AM

Re: Memory problem

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³:[color=blue]
> 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" <hokah@wp.pl> wrote in message news:cvii3e$6gg $1@inews.gazeta .pl...
>[color=green]
>>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[/color]
>
>
>[/color]

**Ed Robichaud** · Nov 13 '05, 08:39 AM

Re: Memory problem

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" <hokah@wp.pl> wrote in message news:cvimr4$sis $1@inews.gazeta .pl...[color=blue]
>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³:[color=green]
>> 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" <hokah@wp.pl> wrote in message
>> news:cvii3e$6gg $1@inews.gazeta .pl...
>>[color=darkred]
>>>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[/color]
>>
>>[/color][/color]

Memory problem

Memory problem

Comment

Comment

Comment