I was just forced to update from Access 2000 to Access 2003. Our company intranet uses an Access database to manage Quality Documents, and one of the fields in that database lists the location of the document so that it can be opened through the intranet. I manage the documents in the database, and that field is a hyperlink so that I can click it in Access and have it open the document that way.
When using Access 2000, when I queried that field from the database I received only the actual address included in the hyperlink field, and was able to create the hyperlink on the intranet page by writing that information directly into the href. Since the update, however, I am finding that any record in which I update the hyperlink changes in behaviour. Although the fields appear to be identical in format to fields that were not updated, when I query the updated fields, they respond with the display text followed by the address text - which results in an unusable link in the href.
Example:
Old hyperlink respone:
#\\ad2\quality\Quality_Documents\Other\DCA001.pdf#
New hyperlink response:
\\ad2\quality\Quality_Documents\Other\DCA001.pdf#\\ad2\quality\Quality_Documents\Other\DCA001.pdf#
How do I stop this behavior?
I have found that if I put a ? at the end of the display text, the link will work on the ASP pages (because URL processing stops at the ?) - this is not the best solution, however, because it is an extra step that the database user has to remember when updating a document.
Any suggestions?
Cheryl dc Kern
When using Access 2000, when I queried that field from the database I received only the actual address included in the hyperlink field, and was able to create the hyperlink on the intranet page by writing that information directly into the href. Since the update, however, I am finding that any record in which I update the hyperlink changes in behaviour. Although the fields appear to be identical in format to fields that were not updated, when I query the updated fields, they respond with the display text followed by the address text - which results in an unusable link in the href.
Example:
Old hyperlink respone:
#\\ad2\quality\Quality_Documents\Other\DCA001.pdf#
New hyperlink response:
\\ad2\quality\Quality_Documents\Other\DCA001.pdf#\\ad2\quality\Quality_Documents\Other\DCA001.pdf#
How do I stop this behavior?
I have found that if I put a ? at the end of the display text, the link will work on the ASP pages (because URL processing stops at the ?) - this is not the best solution, however, because it is an extra step that the database user has to remember when updating a document.
Any suggestions?
Cheryl dc Kern
