Access Database and Music Files

can I store these files in the database?

[too much information]

I have used a database to store image files and have not had a need to try other types of files. However now I am designing a site for a musician and I am wondering if I can store music files in the database as well.

Just to cover all of my bases, what about video files?

[too much information]

HA! My answer was found by hitting F1 on my keyboard... ain't help wonderful?!

For those interested "yes" set the field type to OLE Object and it will hold files up to 1gig depending on disk space.

[defanjos]

I always heard and read that it is better to save only the file name in the DB and the actual file on a folder.

[TheDave]

Yeah I wouldnt go storing files in a access DB for use on the internet. Maybe on a local program it's all good, but across the web I would really avoid this. My theory on using access as a web db is put as little data as possible in the DB and use files for anything larger.

[Mosha]

in my Access atabases i've always gone with just providing the file name path, rather than actual storing the files in the DB. my database seems to run better this way.

Just my 2 penneth