Solved

Access 2013 web app file storage

Posted on 2014-12-29
2
211 Views
Last Modified: 2014-12-30
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
Comment
Question by:pdebaets
2 Comments
 
LVL 10

Accepted Solution

by:
Luke Chung earned 500 total points
ID: 40523714
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
 
LVL 12

Author Closing Comment

by:pdebaets
ID: 40524791
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question