Link to home
Create AccountLog in
Avatar of Michael Vasilevsky
Michael VasilevskyFlag for United States of America

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
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Pleas clearly explain in detail what this means:

<The MS Access frontend would be used to view the metadata and upload/download files.>
Avatar of 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
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Very nice that will certainly get me going in the right direction!
Thanks,

MV