Out of Memory Message

Discussion in 'Access Configuration' started by JamesJ, Apr 28, 2010.

  1. JamesJ

    JamesJ Guest

    Access 2007 sp2
    Vista Basic sp2

    When I tried to open my database today I was unable to. I got that 'Not
    enough memory...' memory message.
    I have never encountered this before except a couple of times when I was
    designing form(s).
    I was unable to open any of my dbs. I have 3 gb of physical ram.
    I needed to reboot and only after the reboot was I able to open my db.
    As far as I can tell I had no problem opening other programs on my system.
    I, of course, didn't try them all.

    Any idea what might have caused this??

    James
     
    JamesJ, Apr 28, 2010
    #1
    1. Advertisements

  2. JamesJ

    pipelette Guest

     
    pipelette, Apr 29, 2010
    #2
    1. Advertisements

  3. JamesJ

    Gina Whipp Guest

    James,

    How big is your database and when was the last time you ran Compact &
    Repair?

    --
    Gina Whipp
    2010 Microsoft MVP (Access)

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    Access 2007 sp2
    Vista Basic sp2

    When I tried to open my database today I was unable to. I got that 'Not
    enough memory...' memory message.
    I have never encountered this before except a couple of times when I was
    designing form(s).
    I was unable to open any of my dbs. I have 3 gb of physical ram.
    I needed to reboot and only after the reboot was I able to open my db.
    As far as I can tell I had no problem opening other programs on my system.
    I, of course, didn't try them all.

    Any idea what might have caused this??

    James
     
    Gina Whipp, May 2, 2010
    #3
  4. JamesJ

    JamesJ Guest

    Frontend database is 1.84 gb and the backend is 1.21 mb - that's megabytes.
    I Compact & Repair 3-4 times a week. If I'm making changes to the db I'll
    Compact & Repair several times doing the design session.
    Again, I this error hasn't occurred since the day of my original post.

    James
     
    JamesJ, May 2, 2010
    #4
  5. JamesJ

    Gina Whipp Guest

    James,

    The FE appears to hitting up against the 2gig limit, which will cause error
    messages to pop up. Why is the FE so big? Do you have temp tables? Are
    you running a lot of update/append/delete/ make table queries in the front
    end?

    --
    Gina Whipp
    2010 Microsoft MVP (Access)

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    Frontend database is 1.84 gb and the backend is 1.21 mb - that's megabytes.
    I Compact & Repair 3-4 times a week. If I'm making changes to the db I'll
    Compact & Repair several times doing the design session.
    Again, I this error hasn't occurred since the day of my original post.

    James
     
    Gina Whipp, May 3, 2010
    #5
  6. JamesJ

    JamesJ Guest

    No temp tables or any queries except for 1 query I run, maybe, once every 2
    weeks.
    I do have 28 forms, 7 macros, 11 reports, and 3 modules.

    James
     
    JamesJ, May 3, 2010
    #6
  7. JamesJ

    Gina Whipp Guest

    I have databases with a lot more then that in the front end and they are no
    where near that size. I would try to import your objects into a new
    database and see what size it grows to. (Why? Because sometimes does a
    poor job of reclaiming space when designing forms and then deleting them.)

    I know you said your database is split but are you storing any tables in the
    front end?

    --
    Gina Whipp
    2010 Microsoft MVP (Access)

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    No temp tables or any queries except for 1 query I run, maybe, once every 2
    weeks.
    I do have 28 forms, 7 macros, 11 reports, and 3 modules.

    James
     
    Gina Whipp, May 4, 2010
    #7
  8. JamesJ

    JamesJ Guest

    I'm sorry.
    I either read the size wrong or I typed it wrong.
    My FE is 1.84 MB.
    And no, I don't store any tables in the FE all are linked.

    James
     
    JamesJ, May 4, 2010
    #8
  9. JamesJ

    Gina Whipp Guest

    James,

    In the famous words of Gilda Radner... **NEVERMIND** Okay well, then since
    the error has not appeared again I have no explanation as to why it appeared
    in the first place. I still might import everything into a new front end
    just in case it is an early corruption issue.

    --
    Gina Whipp
    2010 Microsoft MVP (Access)

    "I feel I have been denied critical, need to know, information!" - Tremors
    II

    http://www.regina-whipp.com/index_files/TipList.htm

    I'm sorry.
    I either read the size wrong or I typed it wrong.
    My FE is 1.84 MB.
    And no, I don't store any tables in the FE all are linked.

    James
     
    Gina Whipp, May 4, 2010
    #9
  10. JamesJ

    JamesJ Guest

    O.K. I'll do that.

    Thanks much,
    James

     
    JamesJ, May 4, 2010
    #10
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.