🚀 go-pugleaf

With all due respect, I seriously doubt that you want to insert 80,000 OLE
objects into your file.
It's a common misconception that Access doesn't store linked files in the
database object.
In fact, it does store the object AND a reference to its source so that it
can be refreshed.
(For an embedded object, the link is not stored, so an embedded object
actually takes a little less storage space.)

I'd urge you to consider redesigning the application so that you store the
file path/name to the document in question, instead of the actual document.
If you make it a hyperlink, your client can open the document simply by
clicking on it.

HTH
    - Turtle

"Collywobbles" <kbannon@+no-spam+iolfree.com> wrote in message
news:T7NG7.11276$j22.23083@news.iol.ie...
> I have been asked to finish a semi complete database. The database
currently
> lists details of each of a clients files and what job they relate to. What
> my role is to get the database to display an icon to the (linked rather
than
> embedded) file. This is easy enough - insert a field and then transfer
over
> each file one by one setting it to be a link to file. Dragging it from
> Windows Explorer into the form field displays the file contant rather than
> its icon (unlike say word) and it also needs to be reconfigured to tell it
> to be a link. However this involves about 10 steps approx and what I have
to
> do is transfer over 80,000 files :(.
> Is there an easier way?
> Thakns
> Killian
>
> --
> *** Remove Spam Trap Before Mailing ***
>
>

As I said, they want about 80,000 files inserted into or somehow openable
from the database !
The client has set up a database which lists the project name etc and
whether drawings etc for that project were designed for that project. What
the client wants is to give us the (AutoCAD) drawings and insert them into
the database. I figured that a link to the file would be considerably
smaller than inserting the file itself.
Anyway, going back to your recommendation, I suppose that we could recommend
that the client use hyperlinks. But if they say no I guess we have a lot of
work to do!
Thanks Turtle
K.


"Turtle" <macdermott@mindspring.com> wrote in message
news:9sgk4r$rne$1@slb6.atl.mindspring.net...
> With all due respect, I seriously doubt that you want to insert 80,000 OLE
> objects into your file.
> It's a common misconception that Access doesn't store linked files in the
> database object.
> In fact, it does store the object AND a reference to its source so that it
> can be refreshed.
> (For an embedded object, the link is not stored, so an embedded object
> actually takes a little less storage space.)
>
> I'd urge you to consider redesigning the application so that you store the
> file path/name to the document in question, instead of the actual
document.
> If you make it a hyperlink, your client can open the document simply by
> clicking on it.
>
> HTH
>     - Turtle

"I figured that a link to the file would be considerably  smaller than
inserting the file itself."

That is incorrect.
When you link an object, the entire object gets inserted, along with
instructions for refreshing it.
So if anything, linking will be larger than inserting the file itself.

It sounds as if you and the client need to sit down and work out the
requirements of the project.
Does the client need to see the drawing embedded in your Access form or
report?
Or should it appear in a separate window?
Do they need to interact with the drawing from your database?  (open it in
its own application?)
If it's going to appear in a separate window, what will trigger this
display?  (a button? a hyperlink? OnCurrent event?)

Another important question:
    Do you need to be able to display multiple records (with pictures) at
the same time  on a form?

Once you have a picture of what the client wants, you can think more
specifically about how to provide it.

     - Turtle


"Collywobbles" <kbannon@+no-spam+iolfree.com> wrote in message
news:PJ9H7.11407$j22.23429@news.iol.ie...
> As I said, they want about 80,000 files inserted into or somehow openable
> from the database !
> The client has set up a database which lists the project name etc and
> whether drawings etc for that project were designed for that project. What
> the client wants is to give us the (AutoCAD) drawings and insert them into
> the database. I figured that a link to the file would be considerably
> smaller than inserting the file itself.
> Anyway, going back to your recommendation, I suppose that we could
recommend
> that the client use hyperlinks. But if they say no I guess we have a lot
of
> work to do!
> Thanks Turtle
> K.
>
>
> "Turtle" <macdermott@mindspring.com> wrote in message
> news:9sgk4r$rne$1@slb6.atl.mindspring.net...
> > With all due respect, I seriously doubt that you want to insert 80,000
OLE
> > objects into your file.
> > It's a common misconception that Access doesn't store linked files in
the
> > database object.
> > In fact, it does store the object AND a reference to its source so that
it
> > can be refreshed.
> > (For an embedded object, the link is not stored, so an embedded object
> > actually takes a little less storage space.)
> >
> > I'd urge you to consider redesigning the application so that you store
the
> > file path/name to the document in question, instead of the actual
> document.
> > If you make it a hyperlink, your client can open the document simply by
> > clicking on it.
> >
> > HTH
> >     - Turtle
>
>
>

I doubt seriously if 80,000 AutoCAD drawings _can_ be inserted into an
Access database.

I don't have code for AutoCad, but you'll find code for programmatically
inserting images into OLE fields in the examples downloadable from
http://members.tripod.com/accdevel. You may have to modify it a bit for
Linked, but, as Turtle pointed out, Linking isn't as cheap as you may have
thought.

"Collywobbles" <kbannon@+no-spam+iolfree.com> wrote in message
news:PJ9H7.11407$j22.23429@news.iol.ie...
> As I said, they want about 80,000 files inserted into or somehow openable
> from the database !
> The client has set up a database which lists the project name etc and
> whether drawings etc for that project were designed for that project. What
> the client wants is to give us the (AutoCAD) drawings and insert them into
> the database. I figured that a link to the file would be considerably
> smaller than inserting the file itself.
> Anyway, going back to your recommendation, I suppose that we could
recommend
> that the client use hyperlinks. But if they say no I guess we have a lot
of
> work to do!
> Thanks Turtle
> K.
>
>
> "Turtle" <macdermott@mindspring.com> wrote in message
> news:9sgk4r$rne$1@slb6.atl.mindspring.net...
> > With all due respect, I seriously doubt that you want to insert 80,000
OLE
> > objects into your file.
> > It's a common misconception that Access doesn't store linked files in
the
> > database object.
> > In fact, it does store the object AND a reference to its source so that
it
> > can be refreshed.
> > (For an embedded object, the link is not stored, so an embedded object
> > actually takes a little less storage space.)
> >
> > I'd urge you to consider redesigning the application so that you store
the
> > file path/name to the document in question, instead of the actual
> document.
> > If you make it a hyperlink, your client can open the document simply by
> > clicking on it.
> >
> > HTH
> >     - Turtle
>
>
>

> Does the client need to see the drawing embedded in your Access form or
> report?
need? I dont know - want? They do!

> Or should it appear in a separate window?
> Do they need to interact with the drawing from your database?  (open it in
> its own application?)
Yes - what they want is to click on the icon and open it in its own program.

I think the easiest way will be to get them to store all the images into a
specific folder and we will make hyperlinks to each of these files.
It doesn't appear feasable to do it the way they want.
Thanks
Killian

Is it an icon they want to click on?
Or a thumbnail?

    - Turtle

"Collywobbles" <kbannon@+no-spam+iolfree.com> wrote in message
news:V6OH7.11561$j22.23945@news.iol.ie...
> > Does the client need to see the drawing embedded in your Access form or
> > report?
> need? I dont know - want? They do!
>
> > Or should it appear in a separate window?
> > Do they need to interact with the drawing from your database?  (open it
in
> > its own application?)
> Yes - what they want is to click on the icon and open it in its own
program.
>
> I think the easiest way will be to get them to store all the images into a
> specific folder and we will make hyperlinks to each of these files.
> It doesn't appear feasable to do it the way they want.
> Thanks
> Killian
>
>