OLE Object

[PSH]

I created a database which was using OLE field to link
Autocad drawings in . Now the customer has updated from
Autcad LT 96 to Autocad LT 2004 and all the old drawing
wont open in Autocad 2004 what can i do to fix this.

PSH

 

[Arvin Meyer]

I created a database which was using OLE field to link
Autocad drawings in . Now the customer has updated from
Autcad LT 96 to Autocad LT 2004 and all the old drawing
wont open in Autocad 2004 what can i do to fix this.

That can be remedied by not using an OLE field. Instead store the path to
the file and use ShellExecute to open the proper program..

http://www.mvps.org/access/api/api0018.htm

If the drawings themselves cannot be opened in the later version, your
customer will have to find a way to convert them.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Hello Arvin

Thank you for the tip !

Maybe my explanation was a little blur
the drawings are stored as an ole object
IN the database for using this drawings in
access report as so on.

So i have to find a way to
still using this OLE object together with
Autocad LT 2004 by changig the ref in the
OLE field so that they can be used with only
Autocad 2004 installed on the Client.

Regards

PSH

 

[Arvin Meyer]

Usually, all you need to change is the control that the object is display
in. Try building a new form for that table and adding a new control that
reads the AutoCad drawing. If it works OK, you can probably just delete and
replace the control in your original form. The OLE Class is in the control,
not in the data it displays.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access