Question regarding linked table

[HWhite]

There is a master db that has a table I want to link to. In that table is a
docpath field that is a hyperlink that works. I did not design this original
db and I cannot change anything with this original db. This db resides on a
doc server.

I created a new db (local workstation) and linked to the table. The
hyperlink does not work. The original hyperlink is not in a unc or drive
letter format. They look like this
"E-File%20Indices/1568/Pleadings/020207-1568-11-19-07-Pleadings.PDF" but they
work on the original db. Not in the linked table. I don't REALLY care about
that as long as I can do a text find/replace in the hyperlink field to
replace "E-File%20Indices/1568" with "t:\", and replace any "/" with "\". IF
I can do that, it will work just fine with a drive mapping (t:\) I have
created.

I would assume to do this I would need a form with a command button to
perform a new table query that opens the linked table, runs the new table
query, performs the rename process, and then saves and opens the resulting
new table in datasheet format. I need help with how to do the renaming
programatically.

Thank you very much and I hope this isn't too confusing.

 

[Tom van Stiphout]

On Fri, 16 Jan 2009 14:22:04 -0800, HWhite

Replacing those substrings is done with - you guessed it - the Replace
function. You can use this function inside of a query:
select replace(replace(myField, "x", "y"), "/", "\") as ReplacedLink
from SomeTable

(replace "x" and "y" with "E-File%20Indices/1568" and "t:\"
and myField with the hyperlink field name)

-Tom.
Microsoft Access MVP

 

[HWhite]

Thanks for the help Tom

On Fri, 16 Jan 2009 14:22:04 -0800, HWhite

Replacing those substrings is done with - you guessed it - the Replace
function. You can use this function inside of a query:
select replace(replace(myField, "x", "y"), "/", "\") as ReplacedLink
from SomeTable

(replace "x" and "y" with "E-File%20Indices/1568" and "t:\"
and myField with the hyperlink field name)

-Tom.
Microsoft Access MVP

 

[Howard Burgman]

There is a master db that has a table I want to link to. In that table is
a
docpath field that is a hyperlink that works. I did not design this
original
db and I cannot change anything with this original db. This db resides on
a
doc server.

I created a new db (local workstation) and linked to the table. The
hyperlink does not work. The original hyperlink is not in a unc or drive
letter format. They look like this
"E-File%20Indices/1568/Pleadings/020207-1568-11-19-07-Pleadings.PDF" but
they
work on the original db. Not in the linked table. I don't REALLY care
about
that as long as I can do a text find/replace in the hyperlink field to
replace "E-File%20Indices/1568" with "t:\", and replace any "/" with "\".
IF
I can do that, it will work just fine with a drive mapping (t:\) I have
created.

I would assume to do this I would need a form with a command button to
perform a new table query that opens the linked table, runs the new table
query, performs the rename process, and then saves and opens the resulting
new table in datasheet format. I need help with how to do the renaming
programatically.

Thank you very much and I hope this isn't too confusing.