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.
Solid_2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JHausmannCommented:
Memory's cheap, buy more.

:)
0
barnackyCommented:
What's happening when the Out of Memory error occurs?
0
abaldwinCommented:
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.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

johnny6Commented:
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
0
tommy_boyCommented:
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.




0
Solid_2Author Commented:
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.
0
JHausmannCommented:
To reduce memory usage, you can make your controls, control arrays. Best way to free up memory problems caused by controls...
0
barnackyCommented:
Get SP3 before trying anything else.
0
tommy_boyCommented:
Know what a swpafile is?
0
mgrevilleCommented:
This seems to be a problem encountered when you run on a pc with 16 Mb RAM.

There are different procedures for WIN 16 and WIN 32, the program you are running is using WIN32 procedures, and the compiler is interpreting them as such, so they will be fine on a 32 Mb machine, but not a 16Mb. You will need to differenciate this so the compiler can read it, eg.

#if win16 then
'Code here
#Else if win32
etc.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
barnackyCommented:
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).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.