[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Inmagic/Access and linking images



Keep your photofiles in a separate directory (which can even sit on another
server).  Then treat them as OLEs.  But the trick is not to embed them, but
to link them.  This should keep your database within reasonable limits.


Ingrid

Ingrid P. Shields
Sr. Archivist
Maps and Land Records
Georgia Dept. of Archives and History
Phone:  404-651-6473
FAX:     404-651-8471
ishields@sos.state.ga.us <mailto:ishields@sos.state.ga.us>


-----Original Message-----
From: schaal [ mailto:schaal@ALEXIA.LIS.UIUC.EDU
<mailto:schaal@ALEXIA.LIS.UIUC.EDU> ]
Sent: Wednesday, May 17, 2000 5:47 PM
To: ARCHIVES@LISTSERV.MUOHIO.EDU
Subject: Re: Inmagic/Access and linking images


Have you tried compacting your database?  Access provides a compaction
program
under Tools, Database Utilities, Compact Database.  This should help the
size
of your file...

Donna

>===== Original Message From Archives & Archivists
<ARCHIVES@LISTSERV.MUOHIO.EDU> =====
>I think I understand, but what I meant to say was that it appears that with
>Access, 2+2 equals 5....For instance we have about 500 images at roughly
>10,000 bytes per image, and the database weighs in at well over 100 MB.
Who
>knew?  I still can't figure out how that many images and just plain text
can
>add up that high.
>
>Bill
>
>-----Original Message-----
>From: Anna Truman [ mailto:atruman@CN.HUC.EDU <mailto:atruman@CN.HUC.EDU> ]
>Sent: Wednesday, May 17, 2000 3:32 PM
>To: ARCHIVES@LISTSERV.MUOHIO.EDU
>Subject: Re: Inmagic/Access and linking images
>
>
>Because photos take a comparatively enormous number of bytes to store -
>there is lots more info in a photo file than in a text file - ergo, your
>database file will grow "disproportionately" as you say.
>----- Original Message -----
>From: "Jackson, Bill" <Bill.Jackson@HARLEY-DAVIDSON.COM>
>To: <ARCHIVES@LISTSERV.MUOHIO.EDU>
>Sent: Wednesday, May 17, 2000 4:11 PM
>Subject: Re: Inmagic/Access and linking images
>
>
>> Craig is correct about Access and inserting files, but we are finding
here
>> that when we attach photo files directly into the record, the file size
of
>> the database (in megabytes) seems to grow at a disproportionate rate.
>>
>> We haven't figured out why yet.
>>
>> If you engage in this kind of thing, you might want to be careful about
>what
>> you insert, how many, how much server space is available, etc.
>>
>> Bill Jackson
>> Senior Archivist
>> Harley-Davidson Motor Company
>> Milwaukee, WI
>>
>>
>> -----Original Message-----
>> From: Wright, Craig [ mailto:craig.wright@MNHS.ORG
<mailto:craig.wright@MNHS.ORG> ]
>> Sent: Wednesday, May 17, 2000 1:03 PM
>> To: ARCHIVES@LISTSERV.MUOHIO.EDU
>> Subject: Inmagic/Access and linking images
>>
>>
>> Just for the record you can link to photo files in Access,
>> link to audio and moving image files,
>> or instead of linking, insert copies of the files directly into the
>> database record.
>>
>> __________________________________
>> Craig G. Wright
>> Associate Curator of Manuscript Acquisitions
>> Minnesota Historical Society
>> 651.296.7989           craig.wright@mnhs.org
>>
>>
>> Show me a sane man and I will cure him for you.
>> Carl Gustav Jung
>>
>> A posting from the Archives & Archivists LISTSERV List!
>>
>> To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
>>       In body of message:  SUB ARCHIVES firstname lastname
>>                     *or*:  UNSUB ARCHIVES
>> To post a message, send e-mail to archives@listserv.muohio.edu
>>
>> Or to do *anything* (and enjoy doing it!), use the web interface at
>>      http://listserv.muohio.edu/archives/archives.html
<http://listserv.muohio.edu/archives/archives.html>
>>
>> Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>
>> Confidential e-mail for addressee only
>>
>> A posting from the Archives & Archivists LISTSERV List!
>>
>> To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
>>       In body of message:  SUB ARCHIVES firstname lastname
>>                     *or*:  UNSUB ARCHIVES
>> To post a message, send e-mail to archives@listserv.muohio.edu
>>
>> Or to do *anything* (and enjoy doing it!), use the web interface at
>>      http://listserv.muohio.edu/archives/archives.html
<http://listserv.muohio.edu/archives/archives.html>
>>
>> Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>
>
>A posting from the Archives & Archivists LISTSERV List!
>
>To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
>      In body of message:  SUB ARCHIVES firstname lastname
>                    *or*:  UNSUB ARCHIVES
>To post a message, send e-mail to archives@listserv.muohio.edu
>
>Or to do *anything* (and enjoy doing it!), use the web interface at
>     http://listserv.muohio.edu/archives/archives.html
<http://listserv.muohio.edu/archives/archives.html>
>
>Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>
>Confidential e-mail for addressee only
>
>A posting from the Archives & Archivists LISTSERV List!
>
>To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
>      In body of message:  SUB ARCHIVES firstname lastname
>                    *or*:  UNSUB ARCHIVES
>To post a message, send e-mail to archives@listserv.muohio.edu
>
>Or to do *anything* (and enjoy doing it!), use the web interface at
>     http://listserv.muohio.edu/archives/archives.html
<http://listserv.muohio.edu/archives/archives.html>
>
>Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>

A posting from the Archives & Archivists LISTSERV List!

To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
      In body of message:  SUB ARCHIVES firstname lastname
                    *or*:  UNSUB ARCHIVES
To post a message, send e-mail to archives@listserv.muohio.edu

Or to do *anything* (and enjoy doing it!), use the web interface at
     http://listserv.muohio.edu/archives/archives.html
<http://listserv.muohio.edu/archives/archives.html>

Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>

A posting from the Archives & Archivists LISTSERV List!

To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
      In body of message:  SUB ARCHIVES firstname lastname
                    *or*:  UNSUB ARCHIVES
To post a message, send e-mail to archives@listserv.muohio.edu

Or to do *anything* (and enjoy doing it!), use the web interface at
     http://listserv.muohio.edu/archives/archives.html

Problems?  Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>