MSFlexGrid and Row cap

Is there a limit to the amount of rows a msflexgid can handle? I'm getting an out of memory error when i hit 12962 rows. I have 27 cols so that means i can only get a grand total of 349947 unique cells. Does this number mean anything to anyone? Any ideas? Thanks in advance.

From MSDN

The minimum number of rows and columns is 0. The maximum number is limited by the memory available on your computer.

That's strange because the MSFlexgrid says that i can't have more than 12962 rows but when i tried the same routine using an MSHFlexgrid i had no problems. Could it be that this quote from MSDN is refering to MSHFlexGrids and not MSFlexGrids?

I think it applies to both.

Are you sure that resources didn't get freed up.

If there was a magic number associated with a limitation, I would expect it to be the equivelant of either a signed or unsigned integer and not an arbitrary number of 12,962.

Well the magic number for MSFlexGrid seems to be 349974 ( the numbre of unique rows) If i decrease the number of columns then i can increase the number of rows proportionally. If you have a second, create a new form and place an MSFlexGrid on that form. Then open the property page and designate 27 cols and 12963 rows. It should give you an error. Then try it again this time using an MSHFlexGrid.

You have proven my (and MSDN's) point. It is a matter of the available memory. Whether the MSHFlexGrid uses memory more efficiently then the MSFlexGrid doesn't eliminate the fact that the maximum number of rows and columns allowed is limited by the available memory.

But how is it that i have the same exact limitations on two different machines with two different amounts of memory? One with 512 MB Ram and the other with 650 MB Ram. Did you get the same limitations?

There really isn't a large difference in memory between 512 and 650.

No I didn't get the same limitations. I couldn't even get up to 349K rows with 1.3GB of memory, but then again, I wasn't willing to shut down all of the programs that I had opened just to prove a point that I know I'm right.

Last time, and believe me.
The maximum number of columns and rows allowed in either a MSFlexGrid or a MSHFlexGrid is limited by the amount of available memory.

Well thanks for your time.

Maybe you can explain what human can possibly look at and process a
grid of information with 349974 cells???

Datacollection that will run for days on end. Collecting every one minute for 9 days will create someting of this size.

You may want to consider collecting the data to a database and then if somebody needs to see pieces of the data, then provide an interface.

I've thought about that, but the only problem is the VB is just a viewer. The software that is actually doing the collection (from a third party) writes the data into a tab delimted text file.

Well it's quiting time. Thanks for all your help guys.

Maybe you could capture the file each day, let it start over with a new file, and import the captured file into a database.