OLE Object from MS Access to a MySQL Table

[aas1611]

Hi,

I don't know which forum (MySQL or MS Access) that can help me, so I decided to put my thread on both. Sorry for the inconvenience.

I want to copy a table from MS Access to a MySQL table.

1.
The problem is, one of the fields in the Access table has data type of OLE Object. What would be the equivalent of OLE Object data type in MySQL?

2.
Quite often that I lost connection to mySQL Server when I'm trying to acess tables in my MS Access that are connected (through) ODBC) to MySQL (Error #2013). Is there a way to fix this?

Thanks for all your helps and clues.

Andre

 

[TonyGroves]

There is no equivalent of OLE Object in MySQL. However, there is a Blob data type which can hold any type of binary data.

When you lose your MySQL connection fails, is the MySQL server still running?

 

[aas1611]

Hi,

So, blob data type would be the best choice? I will give it a try...

My MySQL Server is hosted by a third party, not in the house. If I work directly in the phpmyadmin, I never lose the connection (of course, unless it is idle for quite a while). I lose connection only in MS Access, especially if it is a big table. Is it one of MS Access' downside, or something is not right either in my MS Access or my MySQL hosting?

Andre