Change Link directory

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2003 file that is linked to about 600 files and pictures

I want to change the link from F:\ to C:\ (F is actually the server drive
letter)

Eg. F:\demo\slide1.bmp to C:\demo\slide1.bmp

Any help will be appreciated.

Thank you
 
I have an Access 2003 file that is linked to about 600 files and pictures

I want to change the link from F:\ to C:\ (F is actually the server drive
letter)

Eg. F:\demo\slide1.bmp to C:\demo\slide1.bmp

Any help will be appreciated.

Thank you
Click to expand...

Do you have a table containing a Text field with the path and filename? If
not, how are these files linked?

If you do have a table, you can run an Update query updating the filename
field to

Replace([filename], "F:\", "C:\")

Make a backup of the database first!!

John W. Vinson [MVP]
 
Hi John,

Thanks, it works perfectly.

I also face another issue.

I link a file using a command button.
Me.LinkTo1.SetFocus
DoCmd.RunCommand acCmdInsertHyperlink

However sometimes the address appear as either

C:\BizDemo\Presentation\Slide2.BMP or

.../../../BizDemo/Presentation/Slide2.BMP

I prefer the 1st as the 2nd produces the message "Hyperlink can be harmful..."

Appreciate if you can help in this area too.

AY


John W. Vinson said:
I have an Access 2003 file that is linked to about 600 files and pictures

I want to change the link from F:\ to C:\ (F is actually the server drive
letter)

Eg. F:\demo\slide1.bmp to C:\demo\slide1.bmp

Any help will be appreciated.

Thank you
Click to expand...

Do you have a table containing a Text field with the path and filename? If
not, how are these files linked?

If you do have a table, you can run an Update query updating the filename
field to

Replace([filename], "F:\", "C:\")

Make a backup of the database first!!

John W. Vinson [MVP]
Click to expand...
 
However sometimes the address appear as either

C:\BizDemo\Presentation\Slide2.BMP or

../../../BizDemo/Presentation/Slide2.BMP

I prefer the 1st as the 2nd produces the message "Hyperlink can be harmful..."

Appreciate if you can help in this area too.
Click to expand...

Sorry, neither of these are within my experience - I've used hyperlinks very
little. I'd suggest you repost as a new thread.

John W. Vinson [MVP]
 
OK, thanks again for my 1st problem.

John W. Vinson said:
Sorry, neither of these are within my experience - I've used hyperlinks very
little. I'd suggest you repost as a new thread.

John W. Vinson [MVP]
Click to expand...
 
Back
Top