Hi - new to the list today.

I have a problem. MySQL runs on an NT4 PC and the clients are accessing it through linked tables in an Access 2000 front end. I'd like to use html but I'm no programmer, and don't have much time for this project anyway. It's my first project with MySQL (or any SQL come to that!).

I've converted a 2-table Access 2000 database to MySQL, and everything works ok except that one of the fields contains jpg images of about 20k. If I try to insert jpg's by right-clicking on the field and going to 'Insert Objct', then selecting the file - even if I just link it - I get an error message

Update on link failed [TCX][MyODBC]MySQL (#2006)

I have the latst versions of everything. If I insert a gif into the field, it updates ok. I also have a script that's from the MS web site that will add new images in - that works ok for new images, but I've lost 40 odd that were already there and need to put them back individually.

Can anyone help?

Many Thanks