Jacobingram
Registered User.
- Local time
- Today, 09:56
- Joined
- Sep 15, 2004
- Messages
- 13
I have a large database with many tables, forms and queries. One of the most important tables is the document table, which lists various properties of a document. One of the fields in this table is the doc location, and it is of the file type HYPERLINK. The only reason I have used this file type is that when inputting data in a form, access allows you to drag and drop a file into the 'doc location' text box, and the result will be the files hyperlink.
It is not important that you are able to click on the hyperlink within access, as I have an ASP front end website which one uses to search for documents and access them from there. The problem is that the software I am using to make the ASP takes the text value of the hyperlink field which, for some reason unkown to me (i am relatively inexperienced) comes out in the format 'c:\document.doc#c:\document.doc#'
You can observe this if you make a new field in a table of type hyperlink, type something in, and then change the type to text.
As a result, when the ASP page generates a search result, clicking on a link will usually get you a 'file not found' error. What is even stranger is that file types .doc .ppt .xls will all produce working links (even though they still have the #duplicate.xxx# format), but .pdf .jpg .zip .gif. bmp will not. I am at my wits end, although I have managed to narrow down the problem to this.
What I need is either:
a) A way for users to drag and drop a file into the "doc location" field of my form, but the type of data in the underlying table to be text - this is not possible normally.
b) A way to make access feed the ASP uncontaminated links, without the hashes and duplicates.
c) A miracle!
Thanks for your time
It is not important that you are able to click on the hyperlink within access, as I have an ASP front end website which one uses to search for documents and access them from there. The problem is that the software I am using to make the ASP takes the text value of the hyperlink field which, for some reason unkown to me (i am relatively inexperienced) comes out in the format 'c:\document.doc#c:\document.doc#'
You can observe this if you make a new field in a table of type hyperlink, type something in, and then change the type to text.
As a result, when the ASP page generates a search result, clicking on a link will usually get you a 'file not found' error. What is even stranger is that file types .doc .ppt .xls will all produce working links (even though they still have the #duplicate.xxx# format), but .pdf .jpg .zip .gif. bmp will not. I am at my wits end, although I have managed to narrow down the problem to this.
What I need is either:
a) A way for users to drag and drop a file into the "doc location" field of my form, but the type of data in the underlying table to be text - this is not possible normally.
b) A way to make access feed the ASP uncontaminated links, without the hashes and duplicates.
c) A miracle!
Thanks for your time
