Access 2003 There isn't enough memory to perform this Operations

[Jess]

I have a database that is updated often with no problems. Today I'm trying
to change a title on a form and it's locking up with "There isn't enough
memory to perform this operation"
Open the database - no problem
Select the form and click on Design - the error message opens up.

I'm using Vista & Access 2003 SP3
I also have Access 2007 and same problem comes up.
On Vista the virtual memory is set to Automatic.

Any ideas?

 

[Gina Whipp]

Jess,

Things I would try...

Ummm, make a back-up first, second and third and then....

4. Checking to see if this is the only database in which this happens.
5. Import all objects in a new database and see if it still happens.
6. Check the size of the database and make sure you are not approaching the
2 gig limit. If you are, close run Compact & Repair to get the size down
and you may then have to consider other options if the database size is the
issue.
7. Take a look at http://www.granite.ab.ca/access/corruption/symptoms.htm
as it might be early signs of corruption of a form, table or the database
itself.
8. Check my my recent back-up and see if it happens in that file.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Allen Browne]

Don't know if this will solve your issue, but the April 28 2009 hotfix does
address that error message:
http://support.microsoft.com/kb/970623