Results 1 to 5 of 5
  1. #1
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544

    Question Out of Memory + Form requery

    I have a DB that I have been working on for some time. I am suddenly getting an "Out of Memory" error when I try to requery a form. I have commented out the "On Open Event" code that is in the form that I am trying to requery. Does anyone know how to trouble-shoot this?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,965
    Do you periodically run Compact & Repair?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    jgelpi16 is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Mar 2010
    Location
    Charlotte, NC
    Posts
    544
    Yes, ran compact and repairs, moved to a new "shell" DB....I'm not sure what else to do.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,965
    By new 'shell' you mean a new project? Problem is only with the one form? Try rebuilding form? You could copy/paste the controls to a new form object.

    Otherwise, beyond my experience, nothing else I can offer.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Also check your data sources and queries that are running. I've run into this when a piece of rogue data or record has gotten into my databases.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unbound form requery issue
    By kparker in forum Forms
    Replies: 2
    Last Post: 06-28-2011, 04:22 PM
  2. Requery a form with new criterior
    By nostr4d4m in forum Programming
    Replies: 5
    Last Post: 04-05-2011, 08:57 AM
  3. Requery only one record on a form
    By mkallover in forum Forms
    Replies: 3
    Last Post: 01-26-2011, 09:31 AM
  4. Replies: 1
    Last Post: 03-26-2010, 10:32 PM
  5. Replies: 6
    Last Post: 01-13-2010, 02:41 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums