Solved

How to import a MySQL image into and Access OLE Object field

Posted on 2013-06-21
1
1,414 Views
Last Modified: 2013-08-22
I have a MySQL database and am able to sync data to and from it through an ODBC connection just fine.  I am not however, able to sync images saved in a MySQL table into my Access table (OLE Object field type).

It works fine when i link to an MSSQL db and import into an access table.  I am able to view the images fine in Access but not when i import them from MySQL.  What am i missing?
0
Comment
Question by:wlwestrom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 39287783
You did not state the datatype(s) you are using in MySQL...
... Nor did you state how you were doing the "sync "

In any event, ... the BLOB (B)inary (L)arge (OB)ject datatype that is typically used in MYSQL to store images, is NOT compatible 100% with the OLE datatype in Access.

See this link for working with BLOB data in Access:
http://support.microsoft.com/kb/103257
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question