Solved

Access 2013 web app file storage

Posted on 2014-12-29
2
204 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:
LukeChung-FMS 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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

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…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now