Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Not Enough Free Memory Error (2000 (9.0.4402 SR-1))

    Francois

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Not Enough Free Memory Error (2000 (9.0.4402 SR-1))

    Francois,

    Thanks for the link. That's the error I'm getting, but the possible causes proposed by MS don't apply in my situation (no pictures used, didn't use the Form Wizard, etc.). Also, the problem as described there is supposed to have been fixed with SR-1, which I already have.

    Here's an interesting twist that I discovered since my original post: I was using a Me.Refresh after each update to record the change (so that progressive old and new values would be recorded if one field was changed several times before moving to a different record -- or otherwise updating the underlying table). Well, I changed the Me.Refresh to Me.Recalc and the error is no longer generated! Looking at Access Help, it appears that Refresh (update the underlying table) is the appropriate method to use, but Recalc (recalculate calculated controls) seems to what I want -- i.e., progressive old and new values are logged when one field is changed several times in a row -- and it doesn't generate the error.

    Any ideas out there on what Me.Refresh is doing to cause this error?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Not Enough Free Memory Error (2000 (9.0.4402 SR-1))

    I'm setting up some "audit trail" coding for changes made to a database. When a new value is entered on the form, I use the BeforeUpdate event to capture the old value. In the AfterUpdate event I open a daughter form that shows the name of the field changed, the old value and the new value, the date/time of the change, and provides a memo field to annotate the change. When the form is closed, the information is added as a new record to a log table.

    The problem is that when I make a change, the daughter form opens, I enter the comments and close the form and then I get a "There isn't enough free memory to update the display. Close unneeded programs and try again." (Microsoft Access) error.

    The tables are currently tiny, the whole database is tiny, my machine is not maxed out by any stretch -- any ideas what's causing this message?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Not Enough Free Memory Error (2000 (9.0.4402 SR-1))

    To be honest, no ideas <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Francois

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Not Enough Free Memory Error (2000 (9.0.4402 SR-1))

    It looks as though you had a loop. The me.refresh was changing the values in the control, which triggered the audit routine, which triggered another me.refresh . . . This kept spawning new daughter forms until memory was full.
    David Grugeon
    Brisbane Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •