Form Corruption Problem

#1

I've seen this problem before and am currently experiencing it in a
database that I am building. Sometimes I'll do design changes to a
particular form and close the form. When I try to open the form I
will get an "Out of memory" error and the form will not open.

My only option is to then delete the form and restore it from a
backup. I've tried decompile/compact and repair/compile but the
problem still appears occasionally on the problem form. What sorts of
things can cause corruption of forms like this. I have "Track Name
Autocorrect" switched off.

#2

Wayne wrote:

Quote:

I've seen this problem before and am currently experiencing it in a
database that I am building. Sometimes I'll do design changes to a
particular form and close the form. When I try to open the form I
will get an "Out of memory" error and the form will not open.

My only option is to then delete the form and restore it from a
backup. I've tried decompile/compact and repair/compile but the
problem still appears occasionally on the problem form. What sorts of
things can cause corruption of forms like this. I have "Track Name
Autocorrect" switched off.

Just curious, what version are you discussing?

Have you installed all of the SPs?

Have you installed all the hotfixes as well?

You can go to this link and then select the "CheckForUpdate" in the
upper right part of the document.
http://office.microsoft.com/en-us/do...px?ofcresset=1

#3

Try SaveAsText/LoadFromText:
http://allenbrowne.com/ser-47.html#SaveAsText

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

Quote:

Wayne wrote:

I've seen this problem before and am currently experiencing it in a
database that I am building. Sometimes I'll do design changes to a
particular form and close the form. When I try to open the form I
will get an "Out of memory" error and the form will not open.

My only option is to then delete the form and restore it from a
backup. I've tried decompile/compact and repair/compile but the
problem still appears occasionally on the problem form. What sorts of
things can cause corruption of forms like this. I have "Track Name
Autocorrect" switched off.

Just curious, what version are you discussing?

Have you installed all of the SPs?

Have you installed all the hotfixes as well?

You can go to this link and then select the "CheckForUpdate" in the upper
right part of the document.
http://office.microsoft.com/en-us/do...px?ofcresset=1