Results 1 to 11 of 11
  1. #1
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243

    Images did not transfer when file was moved to another drive

    To clarify -- all the folders are contained in one main folder entitled UC MEXUS Library, which was transferred to another drive. When the transfer was complete the images in the BookCover folder did not transfer.



    Images in folder called BookCover did not transfer when the main folder [UC MEXUS Library]
    Database is in folder called RevisedLibrary


    Attached Thumbnails Attached Thumbnails Move.JPG   Folders.JPG  
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    And what method did you use to move/copy folders? Manually copy/paste with Windows File Explorer?

    How would that be an Access issue?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    John_G is offline VIP
    Windows 10 Access 2016
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Are the cover images actually in the database, or are you using links to the image files? If you are using links, and the full path including the drive letter is in the link, that may be the issue. The images were probably moved properly, but now the links to them are no longer valid.

  4. #4
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    Quote Originally Posted by June7 View Post
    And what method did you use to move/copy folders? Manually copy/paste with Windows File Explorer?
    Response: I copied/pasted the folder containing all the data.

    How would that be an Access issue?
    Response: Sorry -- I'm not sure how it could NOT be an Access issue?

  5. #5
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    The cover images are in a folder, and are linked via a table in a different folder like this:
    C:\Users\Louise\Documents\UC MEXUS Library\BookCover\A\Aboites_ElAgua.jpg

  6. #6
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    Quote Originally Posted by John_G View Post
    Are the cover images actually in the database, or are you using links to the image files? If you are using links, and the full path including the drive letter is in the link, that may be the issue. The images were probably moved properly, but now the links to them are no longer valid.



    The cover images are in a folder, and are linked via a table in a different folder like this:
    C:\Users\Louise\Documents\UC MEXUS Library\BookCover\A\Aboites_ElAgua.jpg

    To June7 & John_G -- Just realized I left out a crucial piece of information. When I copied/pasted the folder on MY COMPUTER to what is a communal drive, I am able to see the images. It's the other person (ahem, my BOSS) who cannot see the images when viewing the folder from HER COMPUTER. Sorry for the oversight.

  7. #7
    John_G is offline VIP
    Windows 10 Access 2016
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    The cover images are in a folder, and are linked via a table in a different folder like this:
    C:\Users\Louise\Documents\UC MEXUS Library\BookCover\A\Aboites_ElAgua.jpg
    That's your issue, then. The links contain the full path, including the Drive designation - in this case C:\, so when you moved the folder UC MEXUS Library (and its subfolders) to another location, the links were no longer valid, and you have to update the links in the table. That is not as difficult as it appears; a single SQL Update statement will do it.

    First, make a backup of your database, just in case (you should always be making backups anyway).

    Then, you use a SQL statement something like this:

    "Update tablename set linkfieldname = replace(linkfieldname,'C:\Users\Louise\Documents\', 'newpathname')"

    This statement will replace all the old path names in the links with the new one, leaving the actual folder part unchanged.

    Replace the names in italics with the names you use in your database.

  8. #8
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    I received you post as I was hitting the send button. Do I still try the SQL statement in light of this information: To June7 & John_G -- Just realized I left out a crucial piece of information. When I copied/pasted the folder on MY COMPUTER to what is a communal drive, I am able to see the images. It's the other person (ahem, my BOSS) who cannot see the images when viewing the folder from HER COMPUTER. Sorry for the oversight.

  9. #9
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    Quote Originally Posted by John_G View Post
    That's your issue, then. The links contain the full path, including the Drive designation - in this case C:\, so when you moved the folder UC MEXUS Library (and its subfolders) to another location, the links were no longer valid, and you have to update the links in the table. That is not as difficult as it appears; a single SQL Update statement will do it.

    First, make a backup of your database, just in case (you should always be making backups anyway).


    Then, you use a SQL statement something like this:

    "Update tablename set linkfieldname = replace(linkfieldname,'C:\Users\Louise\Documents\', 'newpathname')"

    This statement will replace all the old path names in the links with the new one, leaving the actual folder part unchanged.

    Replace the names in italics with the names you use in your database.
    I received your post as I was hitting the send button. Do I still try the SQL statement in light of this information: To June7 & John_G -- Just realized I left out a crucial piece of information. When I copied/pasted the folder on MY COMPUTER to what is a communal drive, I am able to see the images. It's the other person (ahem, my BOSS) who cannot see the images when viewing the folder from HER COMPUTER. Sorry for the oversight.

  10. #10
    snowboarder234's Avatar
    snowboarder234 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    243
    Quote Originally Posted by John_G View Post
    That's your issue, then. The links contain the full path, including the Drive designation - in this case C:\, so when you moved the folder UC MEXUS Library (and its subfolders) to another location, the links were no longer valid, and you have to update the links in the table. That is not as difficult as it appears; a single SQL Update statement will do it.

    First, make a backup of your database, just in case (you should always be making backups anyway).

    Then, you use a SQL statement something like this:

    "Update tablename set linkfieldname = replace(linkfieldname,'C:\Users\Louise\Documents\', 'newpathname')"

    This statement will replace all the old path names in the links with the new one, leaving the actual folder part unchanged.

    Replace the names in italics with the names you use in your database.
    Unfortunately, I do not have any coding skills. I don't have a clue as even where to begin to do a SQL statement. Is their another option?

  11. #11
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    You can use the query object designer to build an UPDATE query object.

    Or you can use the Find/Replace dialog.

    No coding skills required.

    Suggest you make a copy of the table and practice before doing it on your actual data.

    You must be able to see the images because you still have a folder of the images in the original location.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can PM's Contain Images From Local Drive?
    By Micron in forum General Chat
    Replies: 9
    Last Post: 12-22-2017, 07:42 AM
  2. Replies: 5
    Last Post: 05-25-2016, 12:43 PM
  3. need code to copy one file from C drive to E drive
    By ChuckRS in forum Programming
    Replies: 5
    Last Post: 02-23-2015, 07:27 AM
  4. Replies: 10
    Last Post: 03-04-2012, 12:17 AM
  5. Replies: 0
    Last Post: 03-26-2007, 02:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums