469,269 Members | 1,022 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,269 developers. It's quick & easy.

Importing MySQL in MS Access

Hi,
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 1082

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.