I've been quite pleased with linking via MySQL Connector / ODBC 3.51
from Access to a remote MySQL database. However, I haven't figured
out how to establish the link between a Data Type = Attachment field
in Access and some corresponding MySQL field (BLOB, BINARY, I'm not
sure what would work).
Depending on what SQL datatype I define for this field, when I import
that field (link) into the Access table, the Access data type is
either Binary or OLE Object. Access won't allow me to change its data
type to Attachment, giving me the error message: "You cannot set 'This
Field' to the Attachment data type. You can only set a column to the
Attachment data type when that column is first create."
Have you had any success with this?
Cheers
-- Mark Walsen
from Access to a remote MySQL database. However, I haven't figured
out how to establish the link between a Data Type = Attachment field
in Access and some corresponding MySQL field (BLOB, BINARY, I'm not
sure what would work).
Depending on what SQL datatype I define for this field, when I import
that field (link) into the Access table, the Access data type is
either Binary or OLE Object. Access won't allow me to change its data
type to Attachment, giving me the error message: "You cannot set 'This
Field' to the Attachment data type. You can only set a column to the
Attachment data type when that column is first create."
Have you had any success with this?
Cheers
-- Mark Walsen