Access 2007 - There isn't enough memory to perform this operation

[Guest]

Hi
I am trying to use an application written in Access 2003 (Access 2002-2003
file format) in Access 2007. Whenever I try to open a form in design or form
view, I get error 2004:
"There isn't enough memory to perform this operation."
The same happens if I try to import the database into the new accdb file
format. all other objects are imported properly, no forms are imported.
I am running WinXP SP2 on a fully patched machine. I have the following
Versions of Access on this machine (in parallel): 1.x, 2.0, 97, XP, 2003,
2007.

With kind regards
Matthias Kläy

 

[Peter Yang [MSFT]]

Hello Matthias,

I understand that when you try to open a form in Access 2007, you encounter
error "There isn't enough memory to perform this operation." I'd like to
check if the issue occurs for any form or it only occurs with a specific
one. Also, if you open Northiwind.mdb in Access 2007, does the issue still
occur?

If the issue only occurs with a special form, it might be related to custom
Activex controls in the form. To work around the issue, please remove the
custom
ActiveX controls from the form in XP/2003 and then add the control back
once you have imported the form into 2007. The second, was to save the form
as text from XP and then import the form from text in 2007.

You may want to create a new simple form on in Accees XP/2003 in this
database, and try if the problem occur with this new form.

Since you have multiple version of Access installed, you may want to copy
the database to a different test machine with only Access 2007 installed
and let me know the result.

If the issue still occurs, you may remove the data of the database, and
send it to me for testing. Please remove online from my displayed email
address. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Guest]

Hello Peter

Thank you for your help. I followed your suggestions and I found this:

1. No ActiveX controls are involved.
2. I set up a clean installation of Office 2007 on a VM (WinXP SP2 fully
patched) with no other Access versions present. All testing was done on this
machine.
2. Northwind.mdb from Access 2003 is working properly in Access 2007
3. A version of my 2003 DB reduced to a single form does *not* work in
Access 2007.
4. Using SaveAsText and LoadFromText on this form (from Access 2007) into
both a new 2003 .mdb and a new 2007 .accdb results in a form that properly
works.

So I think that I do have a workaround. What is strange is that I routinely
*do* create new versions of my databases using SaveAsText and LoadFromText on
all objects. This process somtimes creates files error.txt, error1.txt etc.
on the hard disk, but these files are always empty. I am going to send you
the problematic .mdb.

Greetings
Matthias Kläy

 

[Peter Yang [MSFT]]

Hello Matthias,

Good to hear you have found a workaround at present.

When I try to open the database in Access 2007, I receive the error message
the exact same as you. However, when I go to Access 2003, I saw some
compile error on function Kopen/Kerr etc sinc they are not included in the
database.

Private Sub Form_Open(Cancel As Integer)

On Error GoTo 0

'Cancel = Not kFOpen(Me)

Exit Sub
'kErrLabel: Call kErr("Form_frm_sysProgress.Form_Open")
End Sub

I comment the code, and save the database. The form can be opened in both
Access 2003 and 2007 but it is blank. From the symptom, it seems the issue
si related to code and it is reference or code related issue. You may try
to add the related module hosting the function to test the issue again on
your side. I am looking forward to your reply. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================