Re: unlinking linked image files.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Currently all my digital assets (scanned drawings, digital artwork, photos,
database thumbnails are on the same computer as the database which is also
the computer I run photoshop on as well as using MS office and typing this
reply. The database was started to catalog my artworks and is evolving (it
hasn't even a whiff of my 12Gb digital photo stuff yet). It is a home-brewed
system.

Also I currently have not yet split the database into front end/back end.

Currently it starting to look like I will have to copy the thumbnails to a
folder that is a subfolder to the database location and manually change each
link. Which means changing 389 links. The thumbnails are spread across 7 or
8 differant folders due to the way the drawings were filed when they were
scanned into the computer.

If I am going to have to do that then I may backup the database and then see
if I can use some sort of table arangement to store the location which acess
refers to to display the image (then this will not be an issue if I have to
shift things again). Only problem is the coding to make it work
Thinking of two tables
1) image id, location code, filename
2) location code, location
otherwise I will end up with 30-40 entries with the same file location per
folder of drawings and 150+(growing) for digital artwork entries

thanks

"Jeff Boyce" wrote:

Perhaps I'm missing something...

I still don't understand, if the bmps are located on, say a network share,
why would moving the front-end do anything to the back-end (i.e., the
"link")?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

"Krazy Darcy" <KrazyDarcy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F93E407D-6A72-4F8C-86A9-9851C3B42FF1@xxxxxxxxxxxxxxxx
I have a database cataloging art works. It has thumbnail images created
specifically for the database. when they were added as each record was
created I clicked on the link file box when I was adding the thumbnail
image.

I believe this means if I change the thumbnail.bmp file it will change in
the database. But if I moove the database I would have to tell access
where
the thumbnails are otherwise I'll loose them in the database.

My question is is there a way of unlinking 500+ thumbnail files without
removing the images from within the database (assuming the images are
embedded in the database)
If not is there an easy way to tell access that the thumbnail folders have
moved (there are 7 differant folders in differant places)


.

Relevant Pages

  • Re: poor performance on first query
    ... > LIKE keyword OR memofield LIKE keyword ORDER BY field3 DESC ... Are the thumbnails embedded in the database or does the database simple have ... a path reference to the thumbnail file? ...
    (microsoft.public.inetserver.asp.db)
  • Re: ACDSee or Bridge
    ... "Live" apps like IrfanView have to make the thumbnails every time you ... "Database" viewers like ThumbsPlus store the thumbnails once made so ... quick viewing access but takes some disk space to store the thumbs. ... Put 10k images in a folder and the database method is quicker by ...
    (alt.graphics.photoshop)
  • Re: Strategy for scanning complete 35mm negative collection
    ... >>thinking of using the scanner as a catalogue device and just save a ... >>Then I can go through the thumbnails and select the pictures I want to ... Can I save just the thumbnails on the Nikon? ... A good Cataloging/Thumbnailing Database is ThumbsPlus. ...
    (comp.periphs.scanners)
  • Re: What is it
    ... It's a Windows system file. ... if you open a folder in Windows ... Explorer that is set to view thumbnails this file ... Essentially it is a system database of the thumbnails of all ...
    (microsoft.public.frontpage.client)
  • Re: Relinking to multiple back end files
    ... may actually wind up in different folders. ... getting Name, Database, and ForeignName from MySysObjects, ... >> several back end data files. ... >> for each distinct source. ...
    (microsoft.public.access.externaldata)