OLE Server Error in Access 2003

[Scott]

I have a form set up in access whereby I insert a thumbnail image of a
product into the database so I can see what it is. This has been working fine
for a couple of years but now when I try to add the image, I get an error
message saying "A problem occurred while Microsoft Access was communicating
with the OLE server or Active X Control. Close the OLE server and restart it
outside of Microsoft Access. Then try the original operation again in
Microsoft Access."

Being a relative bunny at Acess, I have no idea what I am supposed to do.
Can anyone point me in the right direction?

 

[Fred]

Without speaking for Access 2007 (which might have improved in this area)
using the OLE / Object field for pictures is a bad idea with lots of
problems.

Much better to just store the images outside of the db and put the path and
file name in (a) text fields. Then use code to make it visible on forms
and reports.

I did and learned this in the last year from posts in this newsgroup (the
general, DB design or programming groups). I'm not fluent enough to rattle
it off here, but I'd search those groups which will tell you how to do it.