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
Anyone done something like this or know a good place to start?
Any help is appreciated!
Thanks,
MV
Microsoft AccessMicrosoft SQL Server 2008
Last Comment
Jeffrey Coachman
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
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Very nice that will certainly get me going in the right direction!
Thanks,
MV
Thanks,
MV
;-)
<The MS Access frontend would be used to view the metadata and upload/download files.>