3 messages in com.mysql.lists.mysqlRe: Images Blob + Access 97 not viewa...
FromSent OnAttachments
Blake Binkley10 Jun 1999 14:30 
Christian Mack11 Jun 1999 05:22 
Stefan Möhl11 Jun 1999 12:54 
Subject:Re: Images Blob + Access 97 not viewable under forms.
From:Christian Mack (Ma@compal.de)
Date:06/11/1999 05:22:45 AM
List:com.mysql.lists.mysql

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