Re: blob inserted from linux not readable by MS Access

Max <cbm128@yahoo.com> writes:

> The images I upload on the linux server are not
> understandable by Access and the opposite, images I
> upload with Access are not in any reasonable format.
>
> It seems that Access translates them in some obscure
> internal (OLE?) format.

I ran into this recently and didn't find any way around it.  Access
doesn't have any ability to discern a file's type from its contents,
so it has to wrap a BLOB in an OLE object so it can remember what it
is.   My solution was to convince my boss to migrate away (eventually)
from the Access interface to HTML.  :)

The problem might be soluble with enough programming on the Windows
side (you might write a VB clone of the Access app, for example) but I
don't have, or want, enough Windows expertise to say for sure.

-Doug