save voice file

[iccsi]

I would like to store voice file in the tables.
Which type of data I have use for the field and which control can let
users access the voice recorded file.


Your information is great appreciated,

 

[John W. Vinson]

I would like to store voice file in the tables.
Which type of data I have use for the field and which control can let
users access the voice recorded file.


Your information is great appreciated,

Depending on the size of the clips and the number of records, this may not be
very prudent. Audio files (.mp3 format is common but there are others) can be
quite large, and you're limited to 2GByte in any single Access database.

Consider doing as is commonly done for similarly large images - store the
files externally, as files in a folder, and store the filenames in a Text
field in your table. You can then use hyperlinks and/or VBA code to launch an
application that will play the audio.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[iccsi]

Thanks for the message and helping,

Can you please advise the code to run application?

Should I use like following:

DoCmd.RunApp Media Mymp3.mp3 to launch the applicaiton and run the
file?

Your help is great appreciated,

 

[John W. Vinson]

Thanks for the message and helping,

Can you please advise the code to run application?

Should I use like following:

DoCmd.RunApp Media Mymp3.mp3 to launch the applicaiton and run the
file?

Your help is great appreciated,

I've never done it and never worked with audio files, so I'm really not sure.

My first suggestion would be to store the filename as a Hyperlink; if you do
so then launching the hyperlink will run whatever program your PC has defined
as the application for mp3 files. I'll ask some of my colleagues to look in on
the thread, or you may want to post in one of the forums in my .sig; this
newsgroup is no longer officially active and is not supported by Microsoft, so
a good many experts have gone elsewhere.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com