One of the current projects I'm working on is converting an existing Access front end to a web app for a SQL Database. I wasn't involved in the original design of the, formerly, Access db and front end. I have the project nearly complete except for one remaining task, which involved links to part datasheets for a particular part.

The current db has a table with 8 columns "File1" through "File8". For each datasheet created for the part one of these columns is populated with the UNC path to the file, "\\<Server>\<Department>\Documents\<filename>.pdf". The Documents folder currently has over 16000 files stored there. The Access front end has a series of textboxes with associated file save, file open, and delete buttons for each. I could do the same think in the webform where I need to allow access but it doesn't seem very clean.

I've thought about importing the documents to the SQL db then use a fileupload method to maintain them, which I've used in apps for new databases but that seems like a daunting task with the existing db.

I'm wondering if someone might have an example of a way to use the existing file path data in the db and existing document folder to allow access to the documents and the user to manage them?