OLE insertion for many, many cases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

truthseekers,

bearing mind i am very new to access, could someone help me please?

i have looked up my problem in my textbook and on the internet and in the
help feature but, alas, to no avail.

i have a table with about 1 thousand records. one of the fields is "image".
i have a thousand different ".tiff" images ready to put into the table (one
in each record or row). if i use the "textbook" approach to embedd the
images as OLEs then i must manually put my cursor on the cell of the table
and go to "create" from "file", and then browse in the resulting window to
the location of the image file. i would then embed the next tiff file by
doing the same thing on the next row of the table. my problem is that i dont
have the time to do this same process labouriously for a thousand records.

can anyone suggest a means of doing this as a batch or in an otherwise more
efficient way?

PS i also have another project coming up where i need to similarly embedd
several hundred ".wav" sound files into another table and i would like to
apply what i have learned from this question to this task as well.

hoping someone can help!
 
hey douglas!
thanks for your response. clicked on your link but it said it was
unavaiable. have try to see whats going on pls?
 
Try again (keep trying until you get through!).

It looks as though Google may be having some problems, but I was able to get
to it again using that URL.
 
Douglas,
i did try again (and again) and then success!
yes this all looks like it is going to be productive for me. i just need to
apply myself to understanding the discussion and the information referenced.
i will as suggested check the links in the discussion especially tripod and
s. leban's. i am sure i will get satisfaction. so thankyou muchly. i may
need to contact you again if that is alright after i have waded in.
in the interim, could you help me a little further pls? will the
principles discussed in this material regarding image files transfer to sound
files? is there a more specific discussion you know of regarding music or
sound files like wav linking to access tables?
thanks again, douglas.
regards,
 
As is the case with images, you're best off storing the .wav files external
to the database, and simply storing a path inside the database.
 
okay point taken, douglas. but my original question was about the ease with
which i embed this link. ie can i enter more than one link at a time into my
table? i am obviously missing something here. pls bear with me as i am a
novice and i am hung up on the teh way access makes me browse for the link
each time. it woudl be good to insert all the links at once using paste
commonad or something. this is the basis of my question.
 
Peter said:
okay point taken, douglas. but my original question was about the ease with
which i embed this link. ie can i enter more than one link at a time into my
table? i am obviously missing something here. pls bear with me as i am a
novice and i am hung up on the teh way access makes me browse for the link
each time. it woudl be good to insert all the links at once using paste
commonad or something. this is the basis of my question.
Click to expand...

There is a way of doing what you "I think" want to do, however you would
need a reasonable amount of knowledge of VBA. You can write a VBA module to
step through the Directory or Directories (Folder/Folders) which hold your
images/sounds, and add the full path names to your table. Someone out there
may have a canned version of this.

Sorry if this sounds daunting, but it is a solution!

Cheers
AuldMannie
 
thankyou, auldmannie, for your contribution. it helps alot. i would be
interested in learning about VBA programming and would be willing to put the
hard yards in to achieve it.
in accordance with the aims of this discussion group, i can only hope that
someone can contribute a vba routine they have written or at least give me
some idea of how i can start to write one. i am encouraged by the fact that
from what i can envisage about this kind of problem i am trying to tackle, it
would seem to me to be a common type of problem - not confined to my
particularities.
a point of clarification: it seems from your response that you may not be
clear about what i want to do, so i will try to clarify as follows:
1 the problem i want to solve is: to develop an automated way of filling up
an ole field in an access table with a link to .wav files. (one link per
record). the programming problem is therefore input not output. ie it is not
a reporting problem but a data input problem.
2 my access table has two fields: record id and image. (image field is an
ole field.)
3 the table will have over a thousand records, one for each .wav file and
the table will later have another field to do the same thing but with jpg or
tiff image files. in time, the table will expand up to ten fold. so the
problem represents a substantial amount of data input since the ole field
cannot be just pasted in en-mass. it is this substantial clerical data input
load that i am trying to overcome.
4 the origin of each of the .wav files is the one directory on my c drive
(contains a terabyte).
5 the only way i know of putting the .wav destination link into each record
is to do it one at a time manually by using the access procedure published in
their help utility or in a textbook like anderson v (2003: pp118-119) ie:
"place the insertion point in the ole field and choose insert > object and
then in the insrt object dialog box choose create from file, then type the
path and filneame of the ole object (or browse to do so) and then after
entering the filname , chose ok to embed the ole object into the field."
6 it has been established, i think, from douglas's comments above, that the
solution to my problem should concentrate on linking and not embedding due to
limitations in access do with storage of large amounts of ole data directly
in the fields. so far so good; but that still leaves me with the clerical
burden of repeating this procedure for each and every ole object. computers
are meant to improve productivity for routinised and repeated tasks (after a
one-off investment in programming), so there must be an easier way.
i hope i have clarified my purpose auldmannie. if i have not clarified it
enough please let me know before you give up on me.
can any others who might be able to contribute to my solution?
regards
 
Back
Top