# Retriving user name & pass from access database

**URL:** <https://forum.kirupa.com/t/retriving-user-name-pass-from-access-database/117182>\
**Category:** Uncategorized\
**Created:** [July 25, 2004, 2:12pm UTC](https://forum.kirupa.com/t/retriving-user-name-pass-from-access-database/117182 "2004-07-25T14:12:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![darkstyle](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@darkstyle](https://forum.kirupa.com/u/darkstyle)\
**Post date:** [July 25, 2004, 2:12pm UTC](https://forum.kirupa.com/t/retriving-user-name-pass-from-access-database/117182/1 "2004-07-25T14:12:28Z")

</div>

hieeeeeee there…  
i have access database on my site, which contain username and password.  
now i want to identify the username and password from access database from my flash file and let the user know wherether there password is correct or no? if yes then it goes and plays nextFrame();. ( i want my flash file to retrive data from the access file)

please help.

---

<div class="post-metadata">

**Author:** ![darkstyle](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@darkstyle](https://forum.kirupa.com/u/darkstyle)\
**Post date:** [July 25, 2004, 9:15pm UTC](https://forum.kirupa.com/t/retriving-user-name-pass-from-access-database/117182/2 "2004-07-25T21:15:17Z")

</div>

u guess today is sunday thats y no answer 🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 25, 2004, 9:50pm UTC](https://forum.kirupa.com/t/retriving-user-name-pass-from-access-database/117182/3 "2004-07-25T21:50:15Z")

</div>

This will search a MS Access database and send values back to flash. it should give you a good start.

[http://www.digitalosophy.com/Kirupa\_Files/Flash/flash\_asp\_search/](http://www.digitalosophy.com/Kirupa_Files/Flash/flash_asp_search/)

---

<div class="post-metadata">

**Author:** ![darkstyle](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@darkstyle](https://forum.kirupa.com/u/darkstyle)\
**Post date:** [July 26, 2004, 1:17pm UTC](https://forum.kirupa.com/t/retriving-user-name-pass-from-access-database/117182/4 "2004-07-26T13:17:40Z")

</div>

there we go again… well everything is responding correctly, when i click the login button… it verify the username and password from my access data base through login.asp file and it gives me response on my flash that its correct.

```php
Response.Write "message=" & Server.URLEncode(oRS("username"))& "&var2=" & Server.URLEncode(oRS("password"))

```

now my probelm is :  
if the password and username is right i want my flash file to go and play a specific frame… how do i do it?? please help.

```php
 asp code is here.. 
<%@Language="VBScript"%>
<%
 
Dim oRS, oConn
set oRs=server.createobject("ADODB.recordset")
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.open="dsn=DSNvazbo;persist security info=false;"
 
oRS.Open "SELECT * FROM logininfo", oConn, 2, 3
oRS.Find "username = '" & UCase(Request.QueryString("name"))& "'"
oRS.Find "password = '" & UCase(Request.QueryString("password")) & "'"
If oRS.EOF Then
Response.Write "message=Not+Found" & "&var2=Not+found"
Else
Response.Write "message=" & Server.URLEncode(oRS("username"))& "&var2=" & Server.URLEncode(oRS("password"))
End If
oRS.Close
Set oRS = Nothing
oConn.Close
Set oConn = Nothing
%>

```

i have attached the flash file. please help.

---

<div class="post-metadata">

**Author:** ![darkstyle](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@darkstyle](https://forum.kirupa.com/u/darkstyle)\
**Post date:** [July 28, 2004, 6:28am UTC](https://forum.kirupa.com/t/retriving-user-name-pass-from-access-database/117182/5 "2004-07-28T06:28:55Z")

</div>

hmmmmmmmmm