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

How were the links stored in the ancient database?

I couldn't follow the tech when he put the link in the program. If I knew, I wouldn't have this problem now.

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 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