Save data from an ole field into a file

[Guest]

Hi,

Backend database is an access97 but we can upgrade it to any necessary
version.

I have a customer who has a access table which uses an ole field for
document storage.
This field is used for data storage in 3 ways :
1) Create an new object like excel into the ole field
2) Drag a file into the ole field
3) Link a file to the ole field

!! this field can contain about anything from pictures to word, excel,
Autocad,... so probably we also need to do some mimetyping

Does anyone know how this information can be extracted into a usable file
for situation 1 and 2.

For situation 3 we found a workaround.

 

[John Nurick]

Hi JaRa,

When an object is stored in an OLE field, what's stored isn't just the
contents of the corresponding file, but a whole lot of packaging and
preview information, so it's a question of extracting the file data from
the package. Normally you have to do this by automating a
BoundObjectFrame control on a form, using its Verb and Action properties
to launch the OLE object in its parent application and then automating
that. But take a look at www.lebans.com where there may be an
alternative for at least some file types.