No memory

[IPIPKIN]

There are two buttons on form that both open the same form.
One opens correctly, second produces the following message:
"-2147352567 There isn't enough memory to perform this operation. Close
unneeded programs and try the operation again."
There were no changes in program related to the area of those buttons, no
other programs run.
Repairing of database didn't give any results,
Any ideas?
Thanks

 

[Allen Browne]

The symptoms indicate a corruption of the database.

1. Make a backup copy of the mdb file while it is not being used, and
without overwriting any existing backups.

2. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

3. Compact the database to get completely rid of this stuff:
Tools | Database Utilities | Compact

4. Close Access. Decompile the database by entering something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

5. Compact again.

The database should now work correctly.

It may also help to remove any references you don't need. More info about
which ones you do need:
http://members.iinet.net.au/~allenbrowne/ser-38.html

 

[IPIPKIN]

thanks Allen, it worked.
Does this process help from any kind of corruption?

 

[Allen Browne]

I'm guessing that the decompilation was the crucial aspect for this case.
However, there are so many problems resulting from Name AutoCorrect, that it
was important to eliminate it as a possible cause.

Access actually keeps 2 copies of the code: the text version that you read
and edit, and the compiled version that actually runs. If these two become
out of sync, the database is corrupt. Decompilation solves the problem by
discarding the compiled version. Access then recreates the compiled code
from the text, and so the corruption is gone.