Sign in with
Sign up | Sign in
Your question

Need help with a database or something

Tags:
  • PDF
  • Database
  • Business Computing
  • Servers
Last response: in Business Computing
Share
October 10, 2014 3:08:29 AM

Hay, I have alot of PDF files on a server which contains formulas for our company, now the production manager needs access to the pdf's (There is a-lot of them), but he may only print the pdfs.Now i need to setup a Password protected file eg: Formulas(Ask for Password)-CC-Summer-.pdf( as soon as the pdf is accessed a notification must be sent to my boss) any ideas or software i could use. Thanks

More about : database

October 11, 2014 7:11:44 PM

I did something similar many years ago using Microsoft Access. Basically the front-end database (RO, password protected) gave the user access to the directory containing the files. The user (your production manager) would log in, select the desired .pdf(s) for printing via an offered directory list and corresponding check boxes, and then click a "Print" button. At that time, the database would generate a mostly preformatted email via a hard-coded email address to your boss listing the files that were selected for printing. I believe there were some Visual Basic Macros involved to carry out some of the specific steps.

I.e., Access serves as the user friendly framework with the macros actually doing the file culling, printing, and email generation. Actually Visual Basic might be best just to do it all depending on the details. Develope and code step by step: log in via password, find the .pdf files, select the desired .pdf files, print them, generate the email, send the email, log out user when finished. Should not need a lot of error proofing/bullet-proofing for just one two users. Get it all working first and then pretty it up as warranted for the sake of clarity and accuracy.

What you require should be very doable and not too cumbersome (until everyone starts adding whistles and bells). Hopefully you have someone available who can work with Access and VBA. Good luck.
m
0
l
!