Updating a link towards a file

Hi,

I'm using ASP with an Access database.

I got a table named Account containing 4 fields:
AccountName -> unique name
Address -> a memo field.
AccountPlan -> a text 255 chars containing a link/path towards a file somewhere on the user's network.
ExtraDocument -> a text 255 chars containing a link/path towards a file somewhere on the user's network.

When a user creates an Account he must set the AccountName and needs to be able to browse for the file he wants to create a link/path towards. He doesn't have to set a value for Address AccountPlan or ExtraDocument.

Now if that user wants to Update that account he may only update the values for: Address, AccountPlan or ExtraDocument. If he updates AccountPlan or ExtraDocument.

Now when a user chooses update Account. He'll need to see the previous values and then if he chooses so, update some of them.

My problem is that I don't know how to show the old link/path and than let the user choose if he wants to update it if he does he can remove previous data or replace it by browsing for another file.

I tried using <INPUT TYPE=FILE name=etc etc etc> But I haven't been able to (pre)set the value for this type. I do not have to use this type.

It just that it's the only way I can come up with while allowing the user to browse for files.

So it saves the link towars the file.

Please ask if you have questions about this issue.

Thank you.

Que?

use the runat="server" tag for the <input="file">

Then set it progmatically

Hello nemaroller,

I'm using normal ASP not .net, does runat="server" work with normal ASP?

So I do this

<INPUT TYPE=FILE NAME=accountplan runat="server" SIZE=43 >

or this

<INPUT TYPE=FILE NAME=accountplan runat="server" SIZE=43 VALUE=<%=rsAccount("AccountPlan")%>>

and then set the value "progmatically", how do you mean?

Thanks for your reply.