Moving links when saving project to an external hard drive.

[Macon]

I created a database with 3,000 entries. Each entry is linked to a PDF file in a Source Folder. When I move the database and source folder to an external harddrive to deliver to the client, the links still want to link my server rather than the new location on the external hard drive. Does any one know how to fix this without relinking every single file?

[RuralGuy]

Are the PDF's on a SubFolder of where your db resides? If so, you should be able to use CurrentProject.Path to locate them.
CurrentProject & "\YourFolder\YourDoc.pdf"

[Macon]

There is an overall folder project folder that I moved from my server to an external hard drive. Inside the overall folder is the database and the Source File folder. When I click on the link in the database, it tries to link to the server location rather than the source file folder that is now on the hard drive. I'm not clear what you mean by use currentproject.path.

[RuralGuy]

Within your program, how are you referencing the pdf's?

[Macon]

To create the link in the database, I right clicked, went to hyperlink, edit hyperlink, then click on the file I wanted. It ends up looking like this in the database:
E:\LFO RMP AR\Source Files\BLM-0003.pdf I tried removing the E:\ manually, but it still links to the E drive.

[RuralGuy]

Are you using a Form to "click on a link" or just opening the tables directly and clicking on a field?

[Macon]

It's the same in either place. In the form or in the table. It shows a link to the server drive. It doesn't change when I copy it over to an outside drive.

[RuralGuy]

It sounds like you have saved the complete path in the table. You should have just saved the filename in the table and supply the path with code.

[Macon]

Is there somewhere I can get instuctions on how to enter the path with code?

[RuralGuy]

I'm sorry but I took a break. I'd be glad to help. What view is your form in when you shown the records?

[Macon]

I'm sorry but I took a break. I'd be glad to help. What view is your form in when you shown the records?

It's in a data entry form that we created, but also shows up in the table. I pasted a copy below from the table.

Document
Subfolder	ElectronicLocation	Volume
	E:\LFO RMP AR\Source Files\BLM-0001.pdf

[RuralGuy]

What is the FieldType of the field that holds the location? If you just click on it it is probably a hyperlink field.

[Macon]

Yes, it is a yperlink field.

[RuralGuy]

Here's what you can do thru automation: convert the field to just the FileName. Add a click event to the display control that will open the file if it located in .\YourFolder. Will that work for you? You could also add code that would allow the Folder to be anywhere you want it to be.

[RuralGuy]

Is that what you want to do, or would you rather do something else?