Memory and FlexGrid

[Guest]

I have a memory problem and it’s not just old age.

I am using ADP in Access 2002. I have a form on which is a flexgrid
control. Data is imported from a spreadsheet into an array which is then
used to populate the flexgrid. All of this works just fine and dandy and my
users are happy with the results.

I have a concern with the memory this control seems to use. I have copied
this database and replaced the flexgrid with a ListViewControl but apart from
this difference the DB’s are identical.

Here are some results:

Size of DB with Flexgrid 109,298 KB
Size of DB with ListViewControl 12,591 KB

Memory usage when DB opened 14,532 K
Memory usage when flexgrid
form loaded 184,044 K

Memory usage when ListView
form loaded 23,252 K

If possible I would like to keep the FlexGrid so if anyone has any ideas why
I should be getting these results and a possible cure I would be really
pleas3d to hear from you.

Thanks

Mike

 

[MacDermott]

The FlexGrid, as I understand it, was developed for use with Visual Basic;
it's not surprising that it's not as well adapted to Access as are "native"
controls.
In Access, a subform is an extremely flexible native option which can often
provide the features developers are looking for when they reach for the
FlexGrid.

 

[Guest]

In normal cirumstances I would agree, but in this case the ADP will be
converted to ADE. As the number of fields in the imported spreadsheet are
not known at runtime (Anything between 8 and 80) AND we cannot create
additional controls in the sub-form in an ADE environment at this time, I'm
stuck with having to either create a sub form with an untold number of
controls with their visible property set to false and then make them visible
when the number of fields becomes known or use something like flexgrid.

The choice of flexgrid over listview is that the former allows users to edit
cells easier.