Memory problems

[mollow]

Hi,

I'm having a little problem with my database. It keeps popping up a box saying that:

"Not enough memory to update screen". Now this is becoming increasingly frustrating. The computer we use it on is a 266 64mb ram, although we are using Windows NT V4. I'm thinking it could be the NT as I designed the database on a windows 98 computer (with lower spec) and never got an error message.

Anyone got any ideas? We tried upping the virtual memory to 400MB but it didn't appear to make a difference.

Thanks in advance,

Mike

PS Its Access 97

 

[Maquis]

Welcome to memory "problems". I went through this for about 6 months last year.

I'll admit though that your problem is almost the exact opposite of mine. I designed a database on a Win NT 4.0 machine and ran it perfectly, but when it was rolled out to the users (on Win 95 and 98 machines) they all had memory problems. Several computer techies said this was because Win 95 has severe memory management problems which NT doesn't and of course adding more memory to the boxes doesn't help.

That said, here are some ideas.
1. Do your forms have nice, snazzy bitmaps in them? Get rid of them, they're memory hogs. :-( (I know, I love them too, but this will help the memory issue.)

2. Do you have a lot of controls on your form which become visible/invisible depending on current record? Everytime a form or control "pops up" or disappears, then screen has to refresh itself. This also takes a lot of memory. Especially if it's refreshing snazzy bitmaps.

Hope this helps ya some.

Maq B-)
<insert witty signature here>

 

[jrbarnett]

Mike,

I haven't any idea what this is, but have had access 97 run under NT 4 on machines far slower than 266MHz (P90/32Mb if you must know).

You might like to check the following are installed:
1. NT4 service pack 6a.
2. Office 97 SR-2b - even if this is a standalone version of Access.

Something else though: How much data is in the database? If you have a huge number of records in a continuous form or list box, Access will try to load them as a form opens. Therefore, you could try limiting the data that loads by applying some sort of filter or where clause to the form's underlying query or SQL. If the data comes from a remote server, try using a stored procedure to restrict the data that gets passed to the workstation.

You could also try to see if updating video drivers makes a difference.

Hope this helps,

John

 

[mollow]

Thanks guys will give it a go.

We are using Access SR 1 so will d/l the later patch. I'm unsure as to whether we have service pack 6A, our NT diag says 6, although i'm told even if it is 6a it will appear as 6 in winmsd

As for the size. Yes the database as a whole is rather large, although the amount of records that a specific form lists is only very small. Although several forms have multiple subforms on them

Haha and no, no bmp files...i'm far to un-artistic for that ;p

Mike

 

[mollow]

Just to let you know,

This memory problem was fixed in the SR-2 patch. Thanks for your help

Mike