Inserting Autocad drawing as an OLE Object

[John Devine]

The form I am creating will include a small drawing. I
would like to embed an autocad drawing as an OLE object.
While it is simple to do I need the drawing to be a
standard size and shape. And I need to prevent the user
from altering these attributes.
I am not sure that it is even an Access issue. I may have
to write some code for Autocad.
Any ideas would be appreciateed

 

[kevin watkins]

John,

When you insert an ole object from autocad if you are
using a standard drawing remember that it basically opens
the drawing and inserts what you see on the screen. So if
your cad files are not all zoomed to what you want when it
is created you will not get the same size and shape. The
ole object is what you see on the cad page when the
drawing is opened. so if you create the code in cad that
will size the zoom of the drawing to a set value when
opened this may work. I would probably set this on a tool
bar in cad, then open the drawing and set it, save it and
then import the ole in access. If you link the image it
will change if the drawing is changed. This is a good
thing if you want the ole to show what the current drawing
shows. But to sum it up. your right. once you set the
boundry size of the ole, then you need to make sure that
when you capture the ole from cad that it is zoomed to
what you need to insert into access.

Kevin