Link to home
Start Free TrialLog in
Avatar of alevin16
alevin16Flag for United States of America

asked on

Putting PDF files on Azure

I have an Access program that uses Azure for some tables.  Currently, I simply put customer information into a table (name, address, purchase, very basic stuff) and then our users can go to a website and see that information (I used ASPRunner.net to build what I needed because I have no clue how to do it otherwise).

This was fine but now my client would like to run a report from the Access program, save it in PDF format, and have that available to the customer.  How would I do this?  I read something about BLOB storage but I have never done anything like that.

I finished building the code in Access that will allow the system to create the PDF file and save it in a folder on their local server.
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

You can take a look at my Article : https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html
Its for images but you can tweak it to use PDFs.
If you by now can create and save the PDF files, you could save them on an Azure site or upload them via FTP to a folder of your website, while saving a URL to the file in your database.
Then, in your web application, read the URL from the database, retrieve the file, and display it in the browser and/or allow the user to download it.
Azure for some tables
What type of DB, Azure has many different platforms? I assume SQL PaaS. If you are building the PDF you might already have a memorystream that you can convert to byte[] which you can save to a column in the table
Avatar of alevin16

ASKER

Hello All

Sorry for the delay in answering, the coronavirus is causing havoc at work.  I created a varbinary field in a table and I was wondering if there are commands in vba that I use to save the pdf into it?  I know it sounds like I do not know what I am talking about because I don't :D   I have never done anything like this so I am clueless
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you all.  I think I am going to try putting the PDFs in a folder in Azure and then put the link in the field.  Hopefully that will do it.