MP3 in table

[swas]

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

 

[Graham Mandeno]

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

 

[swas]

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

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

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