Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now