Free Memory Space

[lpgagirl]

I have a multi-user DB that is on a large (almost unlimited) server. There are approx. 15 forms on the DB. One form is a tabbed form, with five tabs across the top. Just today, when anyone opens the tabbed form and moves to a specific tab - they get an error "There isn't enough free memory space to update the display. Close uneeded programs and try again". There isn't anything particularly complicated about this form, it is connected to one table. Some fields are memo's. I have contacted the office techy who does not understand why we would get this error. It seems to be an MSAcess generated error. Any idea's on how I can fix this asap?

Thanks in advance,





Jeannie

http://thefloyds.50megs.com/index.html

 

[netooi25]

Microsoft has a help site on this error..

Perhaps it will help.

http://support.microsoft.com/default.aspx?scid=kb;en-us;236977&Product=acc

Netooi

 

[lpgagirl]

Hmmmm I checked out the Microsoft link that you provided, however I do not have a picture on this form. I did not use a predefined style to the form other than the tab form wizard which does not use a picture.

Jean

Jeannie

http://thefloyds.50megs.com/index.html

 

[lpgagirl]

Also, I tried to compact and repair the DB. It goes through the motions and then the main switchboard opens but it still shows compacting status in the bottom left hand corner. It seems to get stuck compacting...how long should I be waiting for this to compact? I've waited 10 min without the status bar NOT moving.

Jean

Jeannie

http://thefloyds.50megs.com/index.html

 

[lpgagirl]

Also, I have a CD copy of the database that was burned just after midnight. I can run the CD version with no errors...hope this helps solve.

Jean

Jeannie

http://thefloyds.50megs.com/index.html

 

[BobStubbs]

As you have a CD copy of the database which works OK, you could try this:

-- Make a copy of your 'damaged' database
-- Log into it as Administrator
-- Delete the form which is playing up
-- Use the File ... Get External Data ... Import menu option to import a new copy of the form, from the working CD copy.

Now run Compact and Repair on the copy database.

If this now works OK, repeat the process on the 'live' database - make sure all other users have logged out first.

Bob Stubbs

 

[willir]

Jeannie

The server is probably not the issue, it is the desktop.

Have you applied the most recent patches for the desktop operating system and Microsoft??

Is there code in the form? Things to look for...
- loops (including from OnCurrent event to another event back to OnCurrent; no second read while advancing through a record set, a loop where no exit condition is met)
- not closing record sets and databases within the code.

A Cartesian query that returns a large X * Y amount of data?

It seems to get stuck compacting...how long should I be waiting for this to compact?

Check out...
Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times
Then compact and repair again.


Richard

 

[lpgagirl]

Thanks for your help all.

FYI
I did install all new patches for MS and Windows. I did import the table and form from the backup copy into the "damaged" DB and the form also had the error once imported. I did't use the procedure that you outlined BOB but I will certainly use it next time. I also went through the code and could not see anything not closed off.

I ended up replacing the entire DB with the back up copy and all seems to be working now. I would love to have known what caused the error but unfortunately I didn't have the time that it would take to figure it out.

Thanks again,

Jeannie

Jeannie

http://thefloyds.50megs.com/index.html