🚀 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 ***
>
>