We help IT Professionals succeed at work.

Access 2013 web app file storage

pdebaets
pdebaets asked
on
286 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.
Comment
Watch Question

President
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.