Copy an 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.
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

 

[LittleSmudge]

Answer to 1 is that you cannot.

What do you have in the OLE Object field in the Access table ?

If it is a file then you create a folder and put all of the files in that folder and you store the Root and Path to the folder as a constant and store the indicidual file name in a VarChar field in the MySQL table.

As for Q2 - the answer lies in WHY are you losing the link - Fix the system problem

Alternativly you'll need to put lots of traps for Error 2013 in your code every time you do an ODBC read or write that copes with the failure.


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.