Flash :: Yes Or No Question, Can Flash Read A Ms Access Database

Flash Read/write To Database
Hi i recently have been experimenting with php and flash and mysql data base's.
I would like to do more stuff with this but i dont want to waste my time learning things that arnt the best. So im a bit confused as far as what these are , are they means to flash editing the database ?
ive heard of flash remoting , cold fusion,amfp, php , actionscript server or sumthing, so many things .....are they different ways of writing to the data base ? im confused. what I really need to know is, whats the easiest and fastest way to read and write databases ? eg shortest code and easiest to understand and the least stuffing around. Thanks!

How Do I Get Flash To Access A Database On A CD...
I am trying to produce a CD using flash as the front end. I would like to know if it is possible to search and publish information from a database on the CD.

Would it be possible to use Visual Basic as the bridge from the database to flash?

cheers,

El-nig

Flash With MS Access Database..?
i am doing a small work which has Flash as the front end and MS Access. I need tutorials on how to do a database connectivity between flash and MS Access.. and also about storing and retriving datas... would be GREAT if you could post me a link or two.. thnkzz

Access Database And Flash
What is the best and easiest way to accomplish connecting to an Access database in Flash? Currently I solved the problem by placing a Flash header on an html page that has the asp form which I hired a programmer to build that loads the Access data. My client likes it but I know it could be better.
Is there a component or software out there for Flash MX that helps me build the form in Flash an will read from the clients Access database? I am no means a programmer so I hate to say it but I need a template or a component for this one.
Your help is greatly appreciated.
Val

Flash / Access DatabAse / ASP Help
I am trying to make a conection from the swf to an asp page in order to update an access data base... but i don't have any script and do not know how to do it, what can i do??

it is a comercial data base, where the users tell us what has they sell. each user has already their personal info in the DB, so when the user update the info, it should be added to it own info. not to others...

it should work like this:

-DB contains info about user "jack"
-jack sells a "toy"
-he fills a form tellin' us what he do
-the data in the form is sent to the DB to be update
-the data is update

is it too dificult??
what can i do or where can i find some info??

Thanks a lot to everyone of you!!!!!!!!!!!!

Ariel.-

Flash 8 And An Access Database
might be a daft question but... is it possible to setup an access database with flash 8 and have it run from a CD?

If so are there any tutorials floating around that could help?

Thanks

Database Help: Flash + Access DB W/ PHP?
How is this done? I've been experimenting a bit with PHP, but I have to admit I don't really know what I'm doing. I know PHP is more often used with MySQL, and Access with ASP, but I'm looking for PHP + Access. Do I need any sort of extra plugin type things to be able to do it?

Would I be able to test and see if its working locally simply by having the access database, php file, and .swf in the same directory? I've seen a fair number of tutorials online, but many are outdated, and many more are confusing and assume prior knowledge.

I want to start incredibly simple. For example, just show a single value from a database in a text field. I have experience using XML in Flash, so I don't need help there. It's all about understanding how the database works, how to set it up, how to test it, etc.

Here's the code I whipped up in the fla:

Code:
xmlLoader.load(new URLRequest("testxml.xml"));
xmlLoader.addEventListener(Event.COMPLETE, xmlLoaded);

function xmlLoaded(event:Event):void {
xml = XML(event.target.data);
xmlList = xml.children();
for(var i=0;i<xmlList.length();i++){
dText.text = xmlList[i];
}
}

So, basically, I need to learn how to set it up on my ftp server, or locally, to make it work, and I need to figure out how to write PHP code that will generate "testxml.xml" with values from the database.

The PHP might be something like this? Obviously it's not going to be MySQL, but I don't know how to set it up for Access.

Code:
<?php

$connect = mysql_connect("localhost", "root", "");
mysql_select_db("FlashDatabase");

$result = mysql_query("select * from Test");
// select all data from the Test table.

// now we are going to write this data into xml for flash

echo("<?xml version="1.0" encoding="iso-8859-1"?>
");
// front slash to skip inverted commas.

echo("<test>
");

while($rows=mysql_fetch_assoc($result)){
echo("<item>". $rows['ValueTest'] ."</item>
");
}
echo("</test>");

?>

Access Database Using Flash
Hi, has anyone attempted to use Flash with scripts to read and write to database on web server or local drive ?

It would be good if a Flash can read and write to databases, which means the content can become dynamic ones.

Any good tips ?

Database Access With Flash
I want to show a table with names from a database in Access XP. How is the simpliest way to do this with Flash MX

Using Flash MX With Access Database ?
Hello,

Anyone knows good tutorials for using FLASH MX with an Access database where a flash created form for example can load directly database saved images and text.

Thank you.

Flash Database Access
Hello,

I am considering various programming languages for creating a web based application that accesses Oracle 10g data. I know virtually nothing about Flash but am versed in HTML, ASP, JSP and PHP.

Are there any native components in Flash that can access a database without relying on programming components of other web laguages (like ASP, JSP etc.)?

Thanks,

Michael42

Flash And Access Database(s)
I'm very experienced with Flash on the animation side, but I am now trying to teach myself the programming side, which I am very new to. My situation/questions is/are this:

I am building a Flash website in which the user selects from a drop down menu in Flash, and that sets a variable I called "tname"(so far this is working fine). I want to be able to have an Access Database set up so that depending on what name is selected, the same set of variables (tpiclink, tage, taddress, etc.) are returned with the values depending on the "tname" variable.

So far, I know how to access varibales from Access databases. So, my questions are these:

1. How do I set up an access database with similar fields but multiple entries for them (ie, address, age, etc. are the same, but these work for multiple names)?

2. Do I need only one Access database or one for each person?

3. How do I send the variable tname from the Flash file?

4. How does the ASP file read it, then send it to the Access database (keeping in mind that I know only fairly basic ASP commands).

5. Is there anything I have overlooked throughout my "quest" to make this work?

Thanks in advance.
The N Man

Flash Can't Read Data From Access Thru Coldfusion?
good day.

i am having trouble here as i just got started out with Coldfusion. i have successfully configure my coldfusion and was able to link to my microsoft Access datasource. i have no problem running my template and data from Access was retrieved successfully.

it was when i tried using flash, i set up a simple button and a dynamic text where when the button is pushed, the SQL from coldfusion will retrieved the data and display it on the dynamic text in flash. the text just wont display even though coldfusion and access was linked properly.

here is the code: for my default.cfm file

<cfsetting enablecfoutputonly="yes">
<cfquery name="bobsbits" datasource="dsnBobstock">
SELECT description
FROM stockdescription
WHERE partname = 'hardhat'
</cfquery>

<cfoutput query = "bobsbits">&code2=#URLEncodedFormat (description)#&</cfouput>

&code2 is the var for the flash dynamic text. Whitespace is even considered here. I used the JDBC-ODBC bridge at my Coldfusion Admin cos thats what they only allow. i am also using win98 with access 2000. With Macromedia Studio MX.i cant seem to rectify the problem. Is it something i am missing here or i need some tweaking in flash. please advice.

here is the code: for my xxx.fla file

on (release) {
loadVariablesNum("default.cfm", 0);
}

this is for the button in frame 1.

ben.

Flash Access To Read The Folder Content
I am trying to make a gallery which I know previously that we could make flash reads the folder "eg. gallery/" by using xml and database and the only thing that we could do it dynamically is only thru php. But I was just wondering whether there's a new method in flash for me to just point a folder and flash reads the whole content in that folders and loop through it?

I asked this because of the purpose of me trying to let people to upload to that folder and if there's any new images, then flash would dynamically reads it.

And also just one more question. Can flash make new folders?

[FMX] Creating A Simple Read & Write Database In Flash?
Hi everyone. I'm new here, nice to meet everyone ^^. I have some big problems(to me T^T) that I really need some advice about.

I'm working on this flash game right now and I need to implement a simple players database...

It needs to be both read and writable . Meaning, when the player register to save his character information , he needs to key in his email and a password and create an account. The account shall store that player's life amount, ammunition etc . All the infos are stored on an external file and retrieved again when the player logins to the game with the email as his login ID. Security issues are not the biggest concern here because its not exactly meant to be an online game and I don't think hacking would be something I need to worry about ^^'''

I've tried Xml with AS, but I realised that, that alone canot allow me to write the player's info into the xml file.

I'm not exactly an mySQL idiot...but I really have very(x2) rusty and limited knowledge of it. All the server topics confuses me and I've had no experience with Microsoft Access. I know neither Php nor ASP =(but they shouldnt be too hard to learn i hope>..<
*prays someone replys soon*

Please Help How Can U Interact With Flash & An Access Database?
Hi!

I'd like to know if there's a way to interact with Flash and a Database made with Access.

I have a db with logins and passwords and a .swf that receives them and makes a query to this db to see if the user is logged or not. How can I do this?

Please help!!

Can We Access Oracle Database Using Flash
I want to know whether we can read and update data of a database in flash or not. If anybody knows Please help me how to interact with database.

Flash MX And Microsoft Access Database
Hi: All

Is it possible using Flash MX to link to Microsoft Access table, so I can save all the data in Access table, and get it when my Flash MX application needs the data: such as wave files, pictures...

Since I have a team project, we will use Access as our database. I will do Flash MX game part, but we will share one database.

Thank you for your time.

James

Can Flash Access MySQL Database?
I was wondering if flash can access mySQL database? If so, how would you be able to access it?

Stand Alone Flash With Access Database
HI,
I need to drag data from a access data base for a stand alone flash movie (.exe). How do i do that? Pls help me..
thanx,
ariya

Flash To PHP To Microsoft Access Database
Hi,

I can get flash to communicate with a PHP file (serverside), but now I want to add records to, delete from, change and write to an Microsoft Access database using PHP code in the file. All the files are in the same directory on the server, so how do I change (etc) the database using PHP code.

Thanx for any help,

I Want To Connect Access Database With Flash
Hi

I want to connect ms access database with flash and add,delete update record from flash

how can i do that

Please help me

waiting for reply.

thanx in advance

ASP Flash Guestbook With Access Database
Hi everyone...
I'm trying and searching for the way how to make a guestbook in flash.

I found many resources and examples but not one of the worked at the end...

Does anyone knows where i can find a workin one with a nice and detailed tutorial? Or even just one that works?
Or better, maybe one of you guys has made one himself and is willing to give me the source! (*.asp, *.fla, *.mdb)

I hope someone can help me with this because its starting to...

thanx thanx thanx!

Database Access - New Things In Flash 8?
I'm about to teach myself how to pull data from an Access database into Flash. I just wondered if there were any changes in Flash 8 to make this process easier. Otherwise, I'll go find some tutorials that were probably written for MX 2004.

Thanks.

P.S. If anyone has any good tutorials, please point them out. I'll probably be going the ASP route for this first try.

Link Flash To Access Database Via Asp Pls
hi

iv tried the tutorial on kirupa
http://www.kirupa.com/developer/acti...s_database.htm

but its not working!!!

please could someone help im attaching the files

could anyone test this anad see where im going wrong please.

thanks!!!

Help On Flash & Access Database Site
I'm creating a full website in Flash MX2004 with ASP and an Access Database. I know how to send information to the database(ala the nice tutorial on this site) and how to recieve information from a text file through variables.

What I'm looking for is if there's an easier way to retrieve the information from the database into the flash file, without having to create an ASP function that writes to the text file.

Also I was wondering if there was a way to send information to the ASP without having to reload the page(therefore restarting the flash movie)?

If anyone could help I would be extremely greatful!

Flash Form, Asp, Sql And Access Database
Hi there !

From one of Kirupa's tutorials I've been trying to implement Digitalosophy's flash 2004 form working with asp, sql and access database.

In the submit button's actions I have :

on(press){
loadVariablesNum("processForm.asp",0,"post");
}

...however it keeps telling me that the page can't be accessed. No other reason given.

All the pages are in place. All the variables are correct. Everything is uploaded.

Is there a mistake in the syntax or am I missing something?

Help greatly appreciated.
Magyar

Database Access With Flash MX 2004?
I'm really hoping someone here can give me good news. I work as a programmer for a County government in the States. Since I have Studio MX 2004 I've been given a new assignment that requires me to finally learn Flash MX 2004. Up to now I've only been using Dreamweaver and Firefox (well and Contribute 2).

Anyway the project is for our online campsite reservations system. The users want me to put a map of the campgrounds that will show available campsites in green and reserved sites in red. The reservation data is stored in an MS SQL Server database.

I've been hunting around for tutorials or how-tos on using databases with Flash MX 2004 and have come up with zip for helpful results. Everything I've found looks to be telling me that I need Flash MX 2004 Professional and a Coldfusion server. Is this true? I mean I'm sure it'd be easier but is it neccessary?

Any suggestions? Sites, books, etc. that would tell me if I can do this with the tools that I've got (we don't have the budget to upgrade).

Linking Flash 8 And An Access Database
I've already got my database done and I need to link it up with my Flash site now... is there a tutorial I can go to or download to show me how I need to script it...
Please help or offer me some direction...

Thanks
Trey

Linking An Access Database With Flash
im trying to link my access dataabse with flash... is there a tutorial i can study or take apart... im not looking to update in flash only view from the website...

within my access db there are about 14 text fields and a pix that i would like to be linked to my flash file...

trey

yes ive checked...15 seconds was one i read...with no luck... please help...

How To Use Flash MX To Connect To MS Access Database
can someone send me the code that could connect flash to ms access to store student name and marks.
thanks

MySQL Database Access (Flash)
How do I access data from an MySQL database, and display the results in Flash?

Retreiving An Access Database Field Into Flash
Dear all,

I need to read a field from an access database directly into a Flash text box, and I wish to use ASP to do this. Let me explain my scenario.

I have a main menu, and one of the options is to Load Text from an access database so that the user can edit and update it. What I am doing is when the user clicks this option, a new MC is loaded, called mcText and in it I wish to load this text field from the db. Can you please tell me how to do that? Are there any tutorials or examples on how I can do this?

Thanks for your help

Connecting Flash MX2004 To An Access Database
Hi,

Im putting together a flash file that will form the basis of a promotional CD. As part of the CD I want to build in a database of our products that are searchable (already created using access), but i dont want the user to come out of the flash environment to do so.

I found somewhere that i would probably have to use an ASP page between the database and the Flash file, using the Load Variables function, but i still havent quite managed to get it to work.

Anyone done this before that can shed some light on the subject???

Cheers!!!

I Want To Connect A Flash Interface With Access Database
hi

i want to connect a flash interface with access database without remoting or asp. locally for a desktop application of a computer based test made wholely in flash.

plz show me any idea by which my problem can be solved.

i have a data base of 10,000 objective type questions with 4 choices ready in access. how can i link it in flash by action script.

waiting for a good reply

bhati

Connecting A Flash Form With An Access Database?
hi everybody

i have this simple question , which is , i want to make a small form in flash (for example enter your name), so when i fell this form and click send , the data will be send to the access database , ofcourse throw an asp file,

so how can i do this move?!?

i try to search for this in the movies section in the site , but i didnt find it

so if anybody have an opening file for thie problem i hope he can put it here , or at least tell me how it works (plz this is very important)

and thnx everybody

Query (Search) MS Access Database Using Flash MX And ASP
Hi All,

This is my first time to play around with Flash and .ASP. I created a contact list form using Flash MX that has couple fields such as: FirstName, LastName, PhoneNumber, Email and Comments. I have the EXACT same fields defined as TEXT on the MS Access database with an addion of ContactID which is a Primary key and Auto/Number. The table on my MS Access database called Contacts.

I can INSERT contacts information from Flash MX to MS Access using .ASP OK however, now I would like to go furthur by Querying/Search the ContactID (which is the MS Access record) and want it to give me the FirstName, LastName, etc... The problem that I have is when i click Search, it does not return anything. The AddContacts.mdb and QueryContacts.asp files are stored under the /cinformation directory and the flash file .html (.swf) is in the same directory as the index.html file. Please help.

This is how I defined the fields in Flash MX.

First Name, Last Name, Phone Number, Email and Comments as Dynamic Text and Variables as follow: wFirstName, wLastName, wPhoneNumber, wEmail, and wComments respectively. By the way, the box where the user enters the ContactID (record #) is Input Text with the Variable of myrecord.

Below is the values that I defined as soon as the Search button is hit.

on (release) {
loadVariablesNum("http://yourwebsite/cinformation/QueryContacts.asp?Record=" add myrecord, 0);
myrecord="";
wFirstName=FirstName;
wLastName=LastName;
wPhoneNumber=PhoneNumber;
wEmail=Email;
wComments=Comments;
Message="Searching in progress .... Please wait";
}

See my QueryContacts.asp file.

<%
'Pass the ID you got back in the field called record
record=request("Record")
Set objconn=server.createobject("adodb.connection")
objconn.open "provider=microsoft.jet.oledb.4.0; data source=" & server.mappath("AddContacts.mdb")
set objrecord=server.createobject("adodb.recordset")
sql="select * from Contacts where ContactID =" & record

objrecord.Open sql,objconn

if objrecord.eof then

Response.Write "Record Not Found "
'response.end
else

FirstName= server.URLEncode(objrecord.fields("FirstName"))
LastName= server.URLEncode(objrecord.fields("LastName"))
PhoneNumber= server.URLEncode(objrecord.fields("PhoneNumber"))
Email= server.URLEncode(objrecord.fields("Email"))
Comments= server.urlencode(objrecord.fields("Comments"))

Response.Write "First Name - " & FirstName & " "
Response.Write "Last Name - " & LastName & " "
Response.Write "Phone Number - " & PhoneNumber & " "
Response.Write "Email - " & Email & " "
Response.Write "Comments - " & Comments & " "

end if
%>

How Can I Link Flash To Open A MS Access Database
How could I link flash to an access database when in IE browser

How To Connect Flash With .mdb Microsoft Access Database
Hi

Can anybody tell i How to connect Flash application with .mdb (microsoft access database)

I want to take some records from that file

Using Flash To Insert Data Into A MS Access Database
Hi, first of all I am using Flash MX 2004 and have Office 2003.

I am trying to use my flash form to insert data into a ms access database but it is not going too well.

I have 4 input fields on the flash form and a submit button, ActionScript on the Submit button is as follows...

on(press){
loadVariablesNum("ProcessForm.asp",0,"post");
}

On my ASP file there is the following code...

<%@language = "VBScript" %>

<%
strFirst = Request.Form("Fname")
strLast = Request.Form("Lname")
strEmail = Request.Form("Email")
strMessage = Request.Form("Message")

Response.Write(strFirst) & " "
Response.Write(strLast) & " "
Response.Write(strEmail) & " "
Response.Write(strMessage)

MyPath=Server.MapPath("Contact.mdb")
Set conn = Server.CreateObject("ADODB.Connection") '
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _"DBQ=" & MyPath

SQL = "INSERT INTO Contacts(FirstName, LastName, Email, Message) VALUES ('"&strFirst&"','"&strLast&"','"&strEmail&"','"&strMessage&"')"
conn.Execute(SQL)
%>

I have the flash form, asp file and database all in the same directory on my hdd, but am havin no luck loading the data into the database...

Can you see any problems anywhere,
Thanks in advance, Lee

Retrieving Data From Access Database From Flash
Hi

Can anyone please tell me how to do the following:

Iv got asp code which retrieves data from the access database, but for the time being i have been using a normal html page, now i want to replace the html page for a flash page. On this flash page there would be one button which when the user clicks should perform the asp action. I think this has got something to do with action scripting but im not sure!!!

Any help would be great..

Many Thanks

Display Content In Flash From An Access Database
Hey...

I have a flash movie which is just a simple animation (which this part is totally irrelevant to what am trying to achieve but anyway) at the end of the animation, I would like to display some names that would scroll from left to right (Like the Star Wars film credits but instead of text going bottom to top it would go from Left to Right). And DON’T HAVE TO FADE OUT.

Now! The problem is that I want it to display the names on a screen from the Database which would be created in Access (have to be access if possible).

So any names entered into the database will get pull out and displayed on the screen and that animation (of names going from left to right) would just loop.

Also the extraction from the DB would be done at runtime, so as soon as you add a name in the database it would display in the next loop of the movie.

Is something like is possible? If so could somebody help me with this? It would be much appreciated.

Many Thanks

Yes Or No Question, Can Flash Read A Ms Access Database

can flash read a Microsoft Access Database? if it can, is there any tuturial out there or at least explain it? Thx in advance.