Movie and Sounds in a form

[Guest]

I have embedded movie in a OLE field stored in a table.
I want to know how can I play the movie on a form.

-I know how to make it when the file is linked (Using the )
-I want to know if the right type of the movie or sound stored in a table
could be "Video Clip" or "Media Clip" or another type...
-I want to know how to play these movies or sounds embedded in a table.

-After that I would know how to embed videos and sounds in a table using
VBA. I find that if I use the Stream object, the loadFromFile method and the
Recordset object, I can storage the movie in a table, but the field will show
"long binary data". How can I play this "long binary data" in a form?

 

[Guest]

Don't Do It!
video clips are not small files. Embedding videos, pictures, or any other
file in a table is a disaster waiting to happen. There is a 2gig limit on
the size of an mdb file. Embedding files will cause you to blow the 2gig
limit making your mdb totally useless very quickly. External linking as you
have been doing is a much better idea.

 

[Guest]

Klatuu, please, understand. It's not for commercial purpose, it's for my
learning, for study. So, I need an answer to my question, not an advice. But
I thank you for your attention, and if you know how to play embedded
videos/sounds, can you share your knowledge?
And I need that very soon.

Thanks