Re: blob inserted from linux not readable by MS Access - Mailing list pgsql-odbc

From Doug McNaught
Subject Re: blob inserted from linux not readable by MS Access
Date
Msg-id m33clf425k.fsf@varsoon.wireboard.com
Whole thread Raw
In response to blob inserted from linux not readable by MS Access  (Max <cbm128@yahoo.com>)
List pgsql-odbc
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

pgsql-odbc by date:

Previous
From: Max
Date:
Subject: blob inserted from linux not readable by MS Access
Next
From: Adrian Klaver
Date:
Subject: Compiling with unixodbc support