insert ole object

  • Thread starter Thread starter tracey
  • Start date Start date
T

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!
 
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.
Click to expand...

Try this article.

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

-- Dev
.
Click to expand...
 
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.
Click to expand...

Try this article.

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

-- Dev
.
Click to expand...
 
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
 
Back
Top