Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Should video clips and photos be stored in a table?

Should video clips and photos be stored in a table?

Should video clips and photos be stored in a table?

Hi guys;

First my expertise is data and report analysis using Access and Excel so building a web app is totally new to me. I am building a data driven web app in Access. I have been using Access desktop apps for a decade but this has never come up. The access web app will allow users to view a large number of instructional videos (no more than 5mb but there will possibly be 100's) as well as storage for their profiles which will have photos (which could be in the 1000's) and possibly their own videos. My question is what is the best solution for storage of videos - do I store them in a table imbedded, do I store a hyperlink to a folder where the videos reside, or is there a storage method I haven't considered. Any advice you can offer is greatly appreciated - I would also really appreciate any suggested links or UDEMY courses that I could access. I'm thinking the closest type of site would be a dating site (it's not)

Many many thanks!!

RE: Should video clips and photos be stored in a table?

I would store the videos in a folder on the web server (or a mount from a file server from the web server), and have a text file folder with the URL relative to a base path in your system configuration.

Example - you have a configuration table/constant which has a value of http://example.com/videos/
You have a table with a list of videos. One field gives the filename, you concatenate the two together to build your URLs, which then go into your HTML application or Acces front end.

Codecademy.com has some free tutorials which may or may not be useful in your case, it depends on your level of expertise in terms of HTML5 multimedia content and embedding that in your applications. There may also be others that would help, I suggest google or another search engine.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close