Hyperlinks field

[Ben M]

Hi All

I have an old database our company uses that I have been asked to look at and i could use some advice. the access database in question is very simple it has one table, the dozen or so fields are all text fields used to store infomation about various parts. all of the complex work is done by a series of ASP pages which display this infomation on an intranet site, because we no longer have anyone on staff familiar with ASP i was asked to create an access front end with some better search functions than the intranet site. since the infomation in question is so simple i thought this would be fairly easy but i have run into a problem, where the website displays hyperlinks to datasheets about the parts, the database only contains a text entry like: 120011/120011.pdf the ASP pages are taking this infomation and then prefixing it to create a hyperlink. Is it possible to replicate this in access as their are over 8000 entries in the database and i don't want to have to change the field to a hyperlink and the set each location properly.

Thanks
Ben

[Robeen]

the database only contains a text entry like 120011/120011.pdf the ASP pages are taking this infomation and then prefixing it to create a hyperlink

What would you like your example text [120011/120011.pdf] to become after the change?
If there is a 'standard' by which the text will be changed - it should be quite easy to write a small subroutine that will go through the 8,000 records and make the required change to the data in that one field.
Again . . . this will work if there is some distinct and logical way in which each of the fields needs to be changed.
Any details you can give will help.

[Ben M]

What would you like your example text [120011/120011.pdf] to become after the change?
If there is a 'standard' by which the text will be changed - it should be quite easy to write a small subroutine that will go through the 8,000 records and make the required change to the data in that one field.
Again . . . this will work if there is some distinct and logical way in which each of the fields needs to be changed.
Any details you can give will help.

Looking at the intranet site it seems that it is prefixing it with "192.168.40.201/escd/datasheets/" with 192.168.40.201 being the IP address of the server the site is stored on. The site itself is accessed by putting 192.168.40.201/escd into a web browser