It is likely to be very helpful in getting useful answers if you provide
detail in the question and use this big white space below the Subject line
to ask it.
Perhaps a better question would be: Is it advisable to consider storing a
movie in an Access database?
Two followup questions to that might be: How big is the file containing the
movie? How many movies would you want to store in the database?
A strictly-limited-to-your-question answer might be: As an OLE Object.
A better (or maybe not better) answer might be: Just store the move in a
Folder, and store its address in the Access database, then play it by using
the Application.FollowHyperlink command (about which, see Access Help in a
Module Window).
I want to store my movies like 1 MB, 2 MB of size into database as an OLE
object.
How can i convert my movies into Byte Array and save them to database and in
future how can I read Byte Array and back to Movie and display it to user.
A movie should be handled the same way pictures or any other file should be
treated. This said, you should only store their paths/filenames rather than
embedding them into your database (this will lead to db bloating). Please
read
I want to store my movies like 1 MB, 2 MB of size into database as
an OLE object.
How can i convert my movies into Byte Array and save them to
database and in future how can I read Byte Array and back to Movie
and display it to user.
I want to store my movies like 1 MB, 2 MB of size into database as an OLE
object.
How can i convert my movies into Byte Array and save them to database and
in
future how can I read Byte Array and back to Movie and display it to user.
There is an example of putting an image file into an OLE Object in the
Imaging Example code at http://accdevel.tripod.com. If you want to store it
as a Binary Large Object (BLOB) in an OLE Field or in a Memo Field (as you
describe, storing it byte-by-byte) , there's an example of doing that, also,
in the same example. The latter approach does NOT allow using the Field as
an OLE Object with the registered software for the file-type displaying /
playing the file.
Storing image files in OLE Objects in Access 2003 and earlier subjects you
to database "bloat", but that _should not_ be the case with files for which
you cannot generate a "thumbnail".
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
