Truncated error MyODBC in MS Access

[hansaplast]

Hi,

I installed MyODBC in windows to access a MySQL database server. In MS Access I've created a link to the database. When I try to update a table, MySQL reports that I cannot update a table (This is fine because I do not have the rights to update a table). Access however does NOT display this error correctly, it truncates the error-string it gets from MyODBC.

I've already tried to get a newer version of MyODBC but that didn't helped. I've also tried to run Access on another OS (win98/NT/2000). I have even tried a newer version of MS Access. That all didn't help.
I get a feeling that there is something wrong with MS Access, because errors are not truncated when I use another prog which can use odbc.
I realy tried everything now and nobody seems to know the answer. But I don't think I'm the only one with this problem.

So if you know the answer, please let me know cause I'm running out of options here. Or If you don't have the problem, maybe you can tell me exactly how you installed mysql, myodbc-drivers, other dirver-updates, etc..

I run MySQL on SCO-Unix. Only thing I havn't tried is running it on a diff. OS.

Thanks,

-Hans