Enormous 2003 file

[CJ]

Hi Groupies

I have a 2003 database that has an actual file size of 4MB. However, when I
am doing development work with this file on my laptop I get the message that
my system has insufficient memory ..... When I check the Task Manager, the
Memory for this file is 132,062 K. When I work with the file on my tower
computer, the memory usage is only 14,848 K. Both computers run Vista and
have the same updates.

The tower is a year newer than the laptop but I don't think that should make
such an enormous difference.
Any ideas?

 

[AccessVandal via AccessMonster.com]

In the VBA Editor, do a compile than do a compact and repair.

As always, close(destroy) all set objects and close unuse connection.

 

[CJ]

Hi

I've done that a number of times....no luck.

What I found (and what appears to be the problem) is that a calculated
control on a report is causing the problem.
The calculated control is simply =[City]&", "&[Province]&" "&[Postal] The
minute I put in the calculation in the text box, I get crashing and/or the
memory problem. I can add those fields individually but not together.

 

[CJ]

Apparently the problem is fixed.

I had to base the report on a SQL statement instead of a saved query.
Now it behaves! I have absolutely no idea why!!!??!!!

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!

Hi

I've done that a number of times....no luck.

What I found (and what appears to be the problem) is that a calculated
control on a report is causing the problem.
The calculated control is simply =[City]&", "&[Province]&" "&[Postal] The
minute I put in the calculation in the text box, I get crashing and/or the
memory problem. I can add those fields individually but not together.

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!

In the VBA Editor, do a compile than do a compact and repair.

As always, close(destroy) all set objects and close unuse connection.

 

[AccessVandal via AccessMonster.com]

Could be a form corruption, make sure you have a backup of this database.