Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2012
    Location
    Blue Springs, Missouri area
    Posts
    2

    Unanswered: database linking problem

    I have a large database that I set up on Access 2007. There are 1648 records. Each record was linked to a photo. The photos were located on the C:disc. I just purchased a new computer and now have Office 2010. The data was transferred to the new computer. I have located the picture file but it is no longer on the C:disc. The original link was set up by a tech back when I was using Access 2003. I need to know how to re-connect my program with the pictures. I also would like to do the same thing with another similar program I am working on and I plan a third similar program in the future. How do I set up link?
    JIM

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    How were the links stored in the ancient database?
    Have a nice day!

  3. #3
    Join Date
    Jan 2012
    Location
    Blue Springs, Missouri area
    Posts
    2
    I couldn't follow the tech when he put the link in the program. If I knew, I wouldn't have this problem now.

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Finding where and how the links to the external files are stored would be the first step to the solution.

    Examine the tables of the database and try to find in which table this kind of information is stored.

    Another solution would consist in asking the person who conceived or installed the original database, but I guess that if you're asking here it's because this is not possible.
    Have a nice day!

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    have you try the search find "C:\" in vb code ALT +F11 to open vb window

    have a look at the tables they mite have the Path there SHIFT double click to open and not run any start up you should see all the tables also check if there are hidden object ie table
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •