[F8] Integrating FLASH with Access Databases

Greetings all!

My question is simple. I have a very basic Access Database. I created a FLASH movie to pull the information dynamically through an ASP page. I attached the code for this process below. If anyone can tell me how to do this in FLASH 8 with current Actionscript I'd be very interested, however it is not why I am posting this question.

My question is how would I display a URL from the Access Database as an actual URL in FLASH? I have the database field listed as a hypertext field. I think the problem is the ASP page pulling the data, losing the hyperlink and feeding the raw text to the FLASH movie without a link. Is there way in FLASH to tell anything with http:// to display as a hyperlink? Or is there a better way to do this?

Another suggestion my be storing images directly in Access. Not sure if that can be done. I'm trying to reference a PDF document through hyperlink or image dynamically from the Access database to FLASH. Hyperlink seemed like the easiest way.

Code:

---

onClipEvent(data)
{
        strName = Name;
        strTelephone = Telephone;
        strCity = City;
        strROC1 = ROC1;
        strNotes = Notes;
        strPosition = "Record " add String(CurrentRecord+1) add " of " add String(TotalRecords);
}

onClipEvent(load)
{
        CurrentRecord = 0;
        loadVariables ("GetDetails.asp?Record=0", this);

}

---