Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Out of memory...

Out of memory...

Out of memory...

Every now and then when I try to open a database in Access 97 I get an error message "OUT OF MEMORY" and it doesn't open it. What could be causing this? I have to reboot to correct this problem. Is there any other form?

RE: Out of memory...

your computer is jsut out of memory.  next time it happens, check your systems resources (right-click on My Computer, then Properties, Performance).  your computer needs rest every now and again, and unfortunately, rebooting is about the only way to really get your resources back up.  you may want to try closing some other programs too, to make more memory available

Brian Famous

RE: Out of memory...

You may be right Famous, after all, the message is pretty obvious, but this only happens in Access; I was running another application at the same time and it didn't seem to hamper the system's performance. I just want to have all bases covered.
I'll be monitoring my system to see if I can pinpoint the exact problem. Thanks.

RE: Out of memory...

I have had that problem when using a fancy background on a form that is loaded several times, MSDN has an article on it for Access
C. Hoole

RE: Out of memory...

What operating system are you using? ie. win95, win98, NT? Win95 and Win98 are not as good at managing memory as NT. I had an access program that got "out of memory" errors on win98 but worked fine under NT. I was doing lots of VB coding and Access was retaining all the VB code in memory whether I was editing the code or not. Microsoft tech support walked me through the solution to release the unedited code, but this was with Access 2000.

I suggest running/editing the program in a different environment, another PC/OS, and see if the problem persists.
It may be something specific to your environment, which should help to focus on the problem. The reboot may temporarily fix the problem but apparently there is a memory or access is requiring more memory than should be necessary.

There is an MS Access form on this site.

RE: Out of memory...

I have had a similar problem when opening mail in Outlook. If there is a problem with Outlook and it is not shut down properly, it leaves Word.exe running. When Outlook is fired back up and I attempt to open an e-mail, Windows indicates that I am out of memory. Instead of rebooting the system, I just shut down word.exe from Task Manager. You may be having a similar problem with Access. Next time you get this message, close the Access application and check to see if it is still running under Task Manager. This will indicate that, at some point, the Access application did not shut down properly.

RE: Out of memory...

That may be the problem Cmmrfrds, i'm running on a Win98 OS Pentium III with 128 Ram, and am coding in Delphi 5; when i'm writing code, most of the time i have other apps running on the background, like MP3 player, Excel, Explorer and of course Deplhi, and when I try to open Access 97 this happens. I don't know if it's the same as with VB6 but it could be. I'll check it out.

RE: Out of memory...

A clarification on the "out of memory" problem I had. The VB code I was talking about was within Access behind events and in various functions. To check this out, open up some VB code in Access and then on the menu bar, for the window the VB code is in, click on window. The only module that should be listed is the one you are currently in. If there are more open, then try closing all the modules and saving.

It has been a while so I forgot some of the specific, but when the problem occurred for me I had Win98 with 128meg of ram so the first thing I did was bump up to 256meg of ram, which made absolutely no difference. When I talked to Microsoft they explained that win98 has a finite allocation of ram for the task. So after a certain point, adding more memory doesn't help. It sounds to me like you have sufficient ram to run Access.

Hope this helps,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close