Video media database with MS Access

Asked By Arthur W Adams 20 points N/A Posted on - 10/25/2013

Hello Techyv Guys,

Is it possible to have Video media database with MS Access, by having Videos saved in MS Access database. Please do the needful for providing me inputs on this regard. If it is not possible, provide me details about how to have Video media in the database along with other textual data.

Regards,

Arthur W Adams

• Status: Open
• Question Views: 786
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Merry Hock 0 points N/A #198907

Video media database with MS Access

Hi Arthur,

There is a way to store videos in an Access database if you create a column with OLE object as the data type. But this is not advised because the database can become bloated in size very quickly and you will have trouble doing the most simple tasks in the database like opening tables and running queries. As a workaround, you can create a hyperlink column and put in hyperlink pointing to the video. It can be located on the internet or your computer. This will keep the database robust at all times.

About Merry Hock

Questions
0

Answers
99

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 11/12/2013
• Question Category: MS Access