Re: Images Blob + Access 97 not viewable under forms.

[Christian Mack]

Blake Binkley wrote:
> 
> I keep getting some message about invalid OLE Object type.

Hi Blake

Access 97 sees all BLOB, TINYBLOB, MEDIUMBLOB, LONGBLOB fields as OLE containers.
If you want to see them as "memo" fields in Access, then you have to change the type of
these fields in mysql to TEXT, TINYTEXT, MEDIUMTEXT or LONGTEXT.

You can do this with something like:
ALTER TABLE yourTableName CHANGE blobFieldName blobFieldName TEXT

Hope this helps
Christian