alevin16
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.
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.
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.
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 tablesWhat 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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Its for images but you can tweak it to use PDFs.