We help IT Professionals succeed at work.
Get Started

how to combine ASP vb and Access databases data wth Flash MP3 player

Last Modified: 2008-02-01
ooking for some initial guideance here.

The task: Client provides music technology lessons in schools - has around 300 pupiils in 10 schools at present. At the end of each term the supplied music tech teacher needs to submit the terms  'tracks' to the companies online 'jukebox' for parents to hear.

I have started by creating a database with 'schools' 'bands (pupils use bandname not personal name for security) 'Term' and 'Track' tables.

I will be using aspupload to upload the MP3 files to the server, and will store the filename in the 'Tracks' table which relates to he band ID.

So, I would like to have a popup window on the site which goes through the selection process school -  term - band - and then the track plays through the embedded SWF player.

I tend to use SwishMax rather than flash - but  have Flash available if needed.

My thought is to have the code in th eplayer use a variable as the track name to play (although not sure how to do this yet). But have also been coming across a lot of references to using XML to supply the track info (I will need to display the band name and name of track but plan to use dynamic text from the recordset based on selection.

Can flash import dynamic data? I could then have the selection menus in te flash movie itself. Would this info come from an XML file? and can xml files be updated as another techer loads up up another track to the database?

I may be making this overly complex - hence the question.

Any advice will be much appreciated.

Thank you


Watch Question
Top Expert 2009
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE