Find the size of OLE/binary data in MSAccess DB

Question

I am trying to find a function in MSAccess that can be used to return the size of data (in bytes). e.g something like

SELECT x.id, sizeof(x.custom_data) AS size

Specifically for OLE data types but anything more general would be cool.

Answer 1

I think that what you are going to want to look at is the ADO Stream object. This data type has a Size property. Here is another link that shows some more of the methods and properties of this data type. Note that you will need to have a reference set to the Microsoft ActiveX Data Objects 2.5 Object Library as specified on the Microsoft page.