asked on

Store PDFs on Host and Catalogue with SQL Server

I'm interested in creating an application that is an MS Access frontend connected to a remote SQL Server 2008 backend that "catalogues" PDF documents on a server. So the PDFs would reside in a simple Windows folder structure, and then SQL Server would store the file name and path, and some metadata about each file. The MS Access frontend would be used to view the metadata and upload/download files.

Anyone done something like this or know a good place to start?
Any help is appreciated!
Thanks,

MV

Jeffrey Coachman

Pleas clearly explain in detail what this means:

<The MS Access frontend would be used to view the metadata and upload/download files.>

Michael Vasilevsky

ASKER

Ok to better illustrate, please find the attached MS Access example: it has one form and one table with a document hyperlink. If I open the form and click the hyperlink it opens the PDF. I want to do the same thing but have the backend be a SQL Server database and the files reside on the remote server, instead of my C:\ drive.

Is this possible? Any examples?
Part two will be vba code to upload the file to the remote server, but that can wait for another question.
Thanks!

MV
Documents-Example.zip

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Michael Vasilevsky

ASKER

Very nice that will certainly get me going in the right direction!
Thanks,

MV

Jeffrey Coachman

;-)