Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-06-21
1
Medium Priority
?
1,451 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

722 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