Solved

Connecting to a Access database to validate information entered

Posted on 2004-08-11
7
145 Views
Last Modified: 2010-04-03
Rite, i have a Flash file called scripts.fla, in this i have 21 different frames. All will a stop function on them so the flash file doesn't kepp playin throught them. The first frame has a Login Screen. It uses Username, and Password as validation to enter a site, my database is called Users.mdb. In this database there is a Table called User Information. In this table there are the following fields:

UserID, which is an Autonumber
Username, which is a text field
Password, which is a text field
First Name, which is a text field
Last Name, which is a text field
Post Code, which is a text field
Secret Question, which is a text field
Secret Queston Answer, which is a text field
E-Mail Address, which is a text field
Recieve News, which is a Yes/No field.
Firstly i need a code which looks in the database for the Username and the associated password which when correct goes opens a new browser and goes tot he url http://www.google.com, when the Username is incorrect goes to frame 2 and plays, when the password is incorrect for the username it goes to frame 3 and plays. The Username input box is called UsernameEntry, and the password input box is called PasswordEntry.



0
Comment
Question by:htgits
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
7 Comments
 
LVL 3

Author Comment

by:htgits
ID: 11771009
The Users.mdb i shosted on my C:\Users.mdb for now, until my flash login works.
0
 
LVL 3

Author Comment

by:htgits
ID: 11771026
Also there is a button called Submit to trigger the validation.
0
 
LVL 3

Accepted Solution

by:
Gertst earned 500 total points
ID: 11771055
Hello htgits,

You can't connect to a database with flash only. You need a server side scripting language also: php and asp are most popular ones. Which one to use depends on the availability of your server.

So please check out what scripting can be used and then we can help you further.

Gert
0
 
LVL 1

Expert Comment

by:techE_or_not_techE
ID: 11774513
For testing purposes, you can install a Developer Edition of ColdFusion on your system to act like a server.  ColdFusion has all of the FlashRemoting capabilities built into it -- just might be easier to find help and tutorials for ColdFusion/Flash solutions on the web, anyway (Macromedia site is a goldmine for these typr of tutorials).
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Failed download 57 593
Accessing Live Dynamic Stream 6 213
Online Course Not Responding 3 98
How do i create a Class that can control the main stage in action script 1 51
I have been doing hardcore actionscripting for some time; and needless to say I have faced a lot of problems in just understanding others' code rather than understanding what the code executes. A programmer's life can become hell when there are a lo…
While working over numerous projects I often had the requirement for doing a screen capture in AS3.0. Unfortunately I found no "ready made" solutions in google search that suited my requirements. But I did come across some great resources which help…
The goal of the tutorial is to teach the user how to live broadcast using Flash Media Live Encoder and connecting it to YouTube to broadcast. Log into your Youtube account, choose live stream settings, start live stream from Flash Media Live Enc…
The goal of the tutorial is to teach the user what frame rate is, how to control it and what effect it has on the video.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question