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
Solved

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

Posted on 2013-06-21
1
1,318 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
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to format one of my field to percent with precision of two? 3 18
default combobox value 12 18
Signature required on a report 5 30
ERROR 3113 MODULEID NOT UPDATABLE 8 18
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

839 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