MP3 in table

  • Thread starter Thread starter swas
  • Start date Start date
Hi swas

It is very unwise to store large chunks of binary data
(pictures/sound/videos/other documents/etc) in your database tables. It
greatly increases the size of your database and the risk of corruption.

In any case, there is no way I know of to play a sound that is stored in a
table - you would need to write code to unload it to a temporary file first,
then play it.

I suggest you store your MP3s in the same folder as your database file, then
store the filename *without the path* in your table. When you want to play
the MP3, you can construct its name by putting together the parts:

strMP3Name = CurrentProject.Path & "\" & Me!MP3Name
 
Graham,

Thanks for the comment. I understand your logic - I was thinking a single
file was more 'self contained' and protected the mp3's from other uses.

I am playing from files very well, including mixer controls etc... Dougs
example was great.


Thanks again.


swas


Graham Mandeno said:
Hi swas

It is very unwise to store large chunks of binary data
(pictures/sound/videos/other documents/etc) in your database tables. It
greatly increases the size of your database and the risk of corruption.

In any case, there is no way I know of to play a sound that is stored in a
table - you would need to write code to unload it to a temporary file first,
then play it.

I suggest you store your MP3s in the same folder as your database file, then
store the filename *without the path* in your table. When you want to play
the MP3, you can construct its name by putting together the parts:

strMP3Name = CurrentProject.Path & "\" & Me!MP3Name

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand



swas said:
Hello,

I have taken advantage of Doug Steele's MP3 player at
http://www.accessmvp.com/DJSteele/SmartAccess.html

Is it possible to save MP3 files in a table, or can they only be played
from
a file?


Thanks in advance


swas
Click to expand...
Click to expand...
 
Back
Top