How To store movie into Access Database?

[Larry Linson]

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

Larry Linson
Microsoft Access MVP

 

[Samie]

Thank you Mr. Larry Linson,

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.

Samie

 

[Daniel]

Samie,

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

http://www.mvps.org/access/forms/frm0030.htm

as for examples on how to setup your db to house the filename/paths..., look
over the following

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb
http://www.rogersaccesslibrary.com/download3.asp?SampleName=PicturesLoad.mdb

--
Hope this helps,

Daniel P

 

[David W. Fenton]

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.

If your movies are 1GB, then you'll only be able to store 2 (if
that) in any single MDB file.

That's just bloody silly, seems to me.

Why do you think you need to store your movies in a database?

 

[Larry Linson]

Thank you Mr. Larry Linson,

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.

Samie

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

Larry Linson
Microsoft Access MVP

 

[Aaron Kempf]

storing objects in a database is a great idea

but MDB has a lot of bloat

u should use SQL Server and Access Data Projects

for the record, storing documents IN A DATABASE increase their availability
and security