Solved

Connecting to a Access database to validate information entered

Posted on 2004-08-11
7
147 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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

I know the transition can be hard. We got used to the ease of use ActionScript 2 had, but honestly, it became problematic later on, especially if designers were involved in the project and found it easy to add code as they saw fit. So, this artic…
I come across a lot of question about how to access things in the document class from a movieclip, or accessing something from a movieclip in the document class. It took me a while to figure this out but once I did it makes life so much easier. …
The goal of the tutorial is to teach the user how to use the auto adjust feature and what the different options do. When your video is not working right you can choose the auto adjust feature to help choose your settings.
The goal of the tutorial is to teach the user how to select which audio input to use. Once you have an audio input plugged into the laptop or computer, you will go into the audio input settings and choose which audio input you want to use.

631 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