Keep Log of the volume of data transference between Excel and Access

[RagonichaFulva]

Hello,

I am trying to test the performance of my excel application. It is an excel front-end that obtains its data from an access database.

I would like to create a text file (this part is already programmed) where to include how much information in Kbytes is tranferred from the access database to the excel frontend. It must reflect the volume of information.

I have checked if the ADODB connection/recordset objects have a property/method that might measure the size of the transferred data with no sucess.

I would much appreciate your assistance in this issue.

[RagonichaFulva]

I solved it with the stream object.

We save the recorset with the SAVE method into a stream object and the stream object has the SIZE property that gives you the size in bytes.

If it is a recordset that we must use to updeta, nevertheless, we must clone the recordset into another recordset (the recordsets must be indexed, so Option 2 is not valid tobe cloned) in order to avoid an update error. So we clone it into another recordset which we save into a stream object.

Hope this helps someone. I can post an example code if needed.