insert object/picture

[SANDEE CARLSON]

-----Original Message-----
I have a school database and I want to insert picture of
school in each record. How do I do that? I tried to
insert a picture but it did not work. How do I insert
picture for each school? There are 123 school in my data
base.

Thanks,

Valerie
.
HI VALERIE,

I HAVE A DATABASE (ACCESS97)WHERE I STORE .TIF FILES IT
SHOULD WORK THE SAME FOR YOUR PICS WHICH MAY BE .GIF
OR .JPG ETC. ANYWAY BE SURE THE FIELD THEY ARE GOING INTO
SAYS THE "DATA TYPE" IS "OLE OBJECT". SO GO TO THE "TABLE"
YOU WANT TO STORE YOUR PIC IN AND OPEN IT IN DESIGN VIEW
THEN CHANGE THE FIELD "DATA TYPE" TO "OLE OBJECT" THAT
SEEMED TO BE THE MAGIC BULLET THAT I HIT UPON THAT HELPED.
I WAS THEN ABLE TO STOP BANGING MY HEAD AGAINST THE FILE
CABINET. LOL

I CAME ACROSS YOU POST BECAUSE I'M HAVING PROBLEMS WITH MY
DB NOW SINCE OUR COMPANY SWITCHED TO USING THE "XP"
OPERATING SYSTEM. FROM WHAT I HAVE READ ON THE KNOWLEDGE
BASE AREA I WOULD HAVE BEEN BETTER OFF IF I HAD DONE
MY "INSERT OBJECT" ITEMS AS .GIF OR .JPG. MY STUFF WORKED
IN OPERATING SYSTEM "NT".

HOPE THIS HELPS. PLEASE EXCUSE USE OF UPPER CASE LETTERS
I'M VISUALLY IMPAIRED AND IT'S EASIER FOR ME TO READ THIS
WAY.