472,145 Members | 1,500 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Importing MySQL in MS Access

I'm building a shell script that store information in a MySQL 5.0
database. One of the data I store in the table is a text file. I use a
BLOB type for this text data.

If I try to import it in MS Access 2002 the BLOB column is converted
to a OLE type, but when I try to open it in access I get this error:

"A problem occurred while Miscrosoft Access was communicating with the
OLE server or ActiveX Control. Close the OLE server and restart it
outside of Microsoft Access. Then try the original operation again in
Microsoft Access."

I know that it's because MS access doesn't know what type of object it
is and with which program it should open it. But I don't know how I can
tell access the type of object it is. Should I create a module to
handle these objects? I'm new to access databases so I don't know where
I should start. If someone has any tips or codes I should use please le
me know.

Should I use another type instead of BLOB?

By the way the MySQL database is created from mysql command line inside
a shell script.

Thanks in advance

Feb 1 '06 #1
0 1133

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Oleg | last post: by
reply views Thread by Robert Morgan | last post: by
reply views Thread by Campbell's List | last post: by
11 posts views Thread by Grim Reaper | last post: by
5 posts views Thread by Vik Rubenfeld | last post: by
reply views Thread by Saiars | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.