Access2000 OLE Server

[Jim Hicks]

I have an Access database with about 600 records. The main
form used has pictures of people (Sr Pictures of
Classmates). All the images are jpgs and stored in a
folder one level below the database.

This issue is regular now. If I to to link/or embed a
photo to in to the text box, I consistantly get this
message : "The connection with the OLE Server was lost, or
the OLE Server encounted an error while you were using it.
Restart the OLE Server and then try the operation again."

To me there is no server involved. Need some help here.
Thanks

 

[Arvin Meyer]

An OLE Server is a program which "serves" the data from the image to the OLE
Client application (in this case Access). For example MS-Paint is an OLE
Server. Try using an Image control instead of an OLE control, and store the
path to the image instead of the image itself. For a method that you can
import into your own database, grab the PictureMgr sample database on my
website.:

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Jim Hicks]

Thanks ... Is the image control a selectable field type as
I do not see it.

 

[Arvin Meyer]

Not a field type, but a control type in Access 97 and later.

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access