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
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.
