asked on

Windows 7 Pro ACCESS 2010 VBA - Out Of Memory (Error 7)

Hi Experts,
I have just run into this error while trying to add another small amount of code to a quite large Procedure.

If I remove the last code it is ok.

I have saved it, done a Compact / Repair and I still get the error.

Is there a way to overcome this error?

Thanks.
Bob C.

Professor J

can you share the code?

Bob Collison

ASKER

Hi Professor,
Unfortunately this application is large and very complex. The only way I have been able to share the code in the past was to create a separate DB with just the code I had a problem with. In this case I don't believe that would provide an accurate representation of the issue.
Thanks,
Bob C.

Professor J

Hi Bob,

i would not understand unless i see that small amount of code.

Bob Collison

ASKER

Hi Professor,
The application is for converting the data from one version of the application to another. The .accdb is just over 100 Meg making it difficult to provide the whole application. In addition the data is all in Back End Tables.

I am attaching a file containing all of the code for this procedure.

It works correctly if the Code for the following steps is removed.
STEP_4590: to the end of STEP_4599:

As you can see in STEP_4593: the following line of code needs to be uncommented however as soon as I do this I get the Error 7 Message.

Thanks.
Bob C.
Period-Event-Module-Conversion-Code-.txt

ASKER CERTIFIED SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bob Collison

ASKER

Hi Professor,

Thanks for the confirmation that this code it too large. I had assumed as much.

I'll leave this open for a couple of days to see if anyone else has comments.

Thanks again,
Bob C.

Professor J

you are welcome Bob, i am glad i was able to help.

Bob Collison

ASKER

Hi Professor,
I would like some additional guidance with regard to doing this. My plan is as follows.

This application is strictly for data conversion. There are currently four Modules in this application with all of the conversion code for all Modules within the one application.

My approach will be to split each Module into a separate .accdb containing only the conversion code for that Module. Each Conversion Module .accdb will then be opened, run and closed in sequence from a Master Conversion Application .accdb.

Each Conversion Module when opened by the Master will execute without User intervention. This will make the individual Modules transparent for the User while I can mange / run them individually for development.

Does this sound like a good approach?

Thanks,
Bob C.