[AccessD] Out of memory error

Hi Arthur:

I have run across that type of error recently. After 2 days of research I
narrowed it down to an embedded MS Access error. There is no way around them
except to rebuild the form and try not to get too fancy... Just use tabs
instead of overlapping fields turned off and on. (The system really does not
like overlapping fields!)... Probably does not like overlapping objects of
the same kind but I did not test that far.

I even went so far as to export the offending form using of course Max's
EatBloat app, imported it into a new and clean MDB and within a couple of
minutes there was the 'insufficient memory' on the screen.

The application that I was having problems with was being built in Access
2003. 

HTH
Jim

  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, March 11, 2010 6:43 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Out of memory error

Hi all,

I am running into a consistent error with a particular app. When I try to
open something, Access tells me that it has insufficient memory to complete
the operation. The box has 4GB of RAM and nothing else is running except SQL
Server. I have tried compact and repair but I still get the error. I even
created a new MDB and imported everything from the old one. Still no joy.
Will Decompile help? I don't suppose it can hurt, but I haven't yet done
that. This  incidentally is Access 2003 with SP3.

Any other suggestions?

TIA,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com