Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

Access 2013 web app file storage

With desktop applications and the need to track many large image files, the approach was to save a link to the file instead of storing the file as a blob directly in the database. That was great, and I've used that for many of my customers.

Now I'm building an Access 2013 web application and I need to do the same thing. I have around 100GB of data in the form of artwork files that need to be uploaded, downloaded, and saved, associated to a particular record. The Azure allocation of file storage for Sharepoint apps is a paltry 1GB. So, where shall I put this 100GB of data? If I find a place to store it online, how do I get my Access 2013 web app to upload the artwork files to the online storage?

Any help would be appreciated.
0
pdebaets
Asked:
pdebaets
1 Solution
 
Luke ChungPresidentCommented:
You can't do that with an Access web app. A Visual Studio .NET app could handle that, but the Access web app doesn't offer that capability with Azure.

That said, there may be a way to do it as a SharePoint file since Access web apps can point to SharePoint lists.
0
 
pdebaetsAuthor Commented:
Thanks Luke. If Luke says it can't be done, then it can't be done.

My plan now is to house the data in ownCloud/Amazon S3 and have users sign on there to do uploads and downloads. Using the Amazon S3 API I may be able to detect when a file is added and update the record status in the Access 2013 database. Requires hybrid database so the desktop portion can run the API. Kind of kludgy solution, I know. Too bad web apps are hamstrung to 1GB.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now