Solid_2
asked on
Out of Memory problem
Hi there,
I've done a small prog that acts as a front end for an access DB. The DB is small (270Kb, 291 regs) and so is the prog (88Kb Compiled to Native Code) The prog works all right but not in all machines. Apart from my Pentium II 350 and a Pentium 100 w/ 32MBs it failed with an Out of memory error when executing on 2 486 w/ 16 and 32 MBs and a Pentium 133 w/ 16 MBs.
Please Advise.
Thank you.
I've done a small prog that acts as a front end for an access DB. The DB is small (270Kb, 291 regs) and so is the prog (88Kb Compiled to Native Code) The prog works all right but not in all machines. Apart from my Pentium II 350 and a Pentium 100 w/ 32MBs it failed with an Out of memory error when executing on 2 486 w/ 16 and 32 MBs and a Pentium 133 w/ 16 MBs.
Please Advise.
Thank you.
What's happening when the Out of Memory error occurs?
I have some HUGE applications reading 17 - 20 compacted Access Databases. These apps run fine right down to a couple of 486dx2-66's with 32 megs. One thing that we are careful about is to set all recordset and database objects to Nothing when we are finished with them. Otherwise they will sit in Ram until usually the form is closed.
There are literally millions of things in your program that could cause an out of memory problem. Could you show us what your small program looks like?
John
John
The important thing here is WHAT OPERATING ststem are you useing?
Nt needs 64 mb to start and a decent swapfile size, part from that it has nothing to do with memory as a ram thing. It could be the swap file size - or a corrupt dll can cause this as well.
One other thing to look at is memory leaks. On Nt load Task mamanger and monitor resources before loading and after your app has loaded.
Nt needs 64 mb to start and a decent swapfile size, part from that it has nothing to do with memory as a ram thing. It could be the swap file size - or a corrupt dll can cause this as well.
One other thing to look at is memory leaks. On Nt load Task mamanger and monitor resources before loading and after your app has loaded.
ASKER
Well, Thanks for the comments. Now answering to the questions above:
I'm running Windows 95 and use VB5 (no SPs).
I already checked the Resource monitor when the error occurs and it is all over 75% free.
My little program is a front end navigator for a couple of tables in an Access DB containing Hotel data (name, address...) It allows insertion and querying. When it starts there is a pwd form, on clicking the OK button the main form is suppose to load, that's when the error occurs. This main form has quite a few controls including the MS Forms 2.0 which are the Access95 controls, apart from DBCombos, DBLists, 1 FlexiGrid and assorted TextBoxes and Labels.
Thank you.
I'm running Windows 95 and use VB5 (no SPs).
I already checked the Resource monitor when the error occurs and it is all over 75% free.
My little program is a front end navigator for a couple of tables in an Access DB containing Hotel data (name, address...) It allows insertion and querying. When it starts there is a pwd form, on clicking the OK button the main form is suppose to load, that's when the error occurs. This main form has quite a few controls including the MS Forms 2.0 which are the Access95 controls, apart from DBCombos, DBLists, 1 FlexiGrid and assorted TextBoxes and Labels.
Thank you.
To reduce memory usage, you can make your controls, control arrays. Best way to free up memory problems caused by controls...
Get SP3 before trying anything else.
Know what a swpafile is?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Win16 and Win32 shouldn't have anything to do with 16MB and 32MB of RAM. Win16 are 16-bit dll's (i.e. Windows 3.x) and Win32 are 32-bit dll's (i.e. Windows 9x and Windows NT).
:)