insert ole object

[tracey]

I need to insert an ole object into a table. I want do it
with code. I cannot find an example anywhere. I am using
a common dialog control to navigate and retrieve the file
path. What is the command to insert the object(file) into
the table.

As always you help is invaluable. Thank You!

 

[Dev Ashish]

I need to insert an ole object into a table. I want do it
with code. I cannot find an example anywhere. I am using
a common dialog control to navigate and retrieve the file
path. What is the command to insert the object(file) into
the table.

Try this article.

[ http://support.microsoft.com/default.aspx?scid=kb;en-us;103257 ]

-- Dev

 

[Don]

Try searching on the "SoucreDoc" property from Access's VB
Editor Help. The description of the property seems to have
a fairly relevent example. Please note that I haven't
tried this though.

Don

-----Original Message-----

[email protected]:

I need to insert an ole object into a table. I want do it
with code. I cannot find an example anywhere. I am using
a common dialog control to navigate and retrieve the file
path. What is the command to insert the object(file) into
the table.

Try this article.

[ http://support.microsoft.com/default.aspx?scid=kb;en- us;103257 ]

-- Dev
.

 

[Don]

One other thing... I'm just now working with a database
that is using inserted OLE objects and the file size on
this sucker has gotten big. This is someone elses DB and
I'm trying to find a way to reduce its size. I have
limited knowledge in this area, but what I have seen is
that a single OLE link (not embedded, but just the link)
is worth about 400K of file size.

Don

-----Original Message-----

[email protected]:

I need to insert an ole object into a table. I want do it
with code. I cannot find an example anywhere. I am using
a common dialog control to navigate and retrieve the file
path. What is the command to insert the object(file) into
the table.

Try this article.

[ http://support.microsoft.com/default.aspx?scid=kb;en- us;103257 ]

-- Dev
.

 

[Larry Linson]

The imaging sample databases at http://accdevel.tripod.com have an example
of programmatically inserting OLE objects into a table. Feel free to use
that code (it isn't intended to be "finished application code") as a
starting point for your own.

Larry Linson
Microsoft Access MVP