# Fetching information from microsoft access to flash with ASP with ASP

**URL:** <https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639>\
**Category:** programming\
**Created:** [August 5, 2003, 1:56am UTC](https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639 "2003-08-05T01:56:23Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![SLamaJama](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@SLamaJama](https://forum.kirupa.com/u/SLamaJama)\
**Post date:** [August 5, 2003, 1:56am UTC](https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639/1 "2003-08-05T01:56:23Z")

</div>

im looking for is a code which allows me to check the information without using the flash application…for example …viewing the file in IE and when the correct user log in a smallwindow will appear saying that the pserson has logged in for example … [Welcome Syed] and the user’s loggin info will be recorded in the database in any means whether its by a tick or just an indication…

---

<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:** [August 5, 2003, 2:22am UTC](https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639/2 "2003-08-05T02:22:05Z")

</div>

ok well here goes

login.asp

```php

<% @Language="VBScript"
<% 
	un=request("un") 'request form login variables
	pw=request("pw")

Dim conn, rsNames 'delcare some vars

MyPath=Server.MapPath("database.mdb") 

Set conn=Server.CreateObject("ADODB.Connection") 

conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ 
	"DBQ=" & MyPath 

SQL= "SELECT * FROM ADMIN"  

Set rsNames = conn.Execute(SQL) 'execute the sql query

		
			Match = "no"
		
			Session("un")=un
	        Session("ps")=ps
			

Do While Not rsNames.EOF 'execute sql query until no more entries

If un=rsNames("USERNAME") And pw=rsNames("PASSWORD") Then
			
		Match= "yes"

	    End if
%>		

<% rsNames.MoveNext %>

<% Loop %>

<% Response.Write (Match) 
	    If Match= "yes" then 
		Response.Redirect un & "yourprotectedpage.asp" 'this can be the page you want to protect
	    End If
%>

```

that will check a db with a table called ADMIN with fields called USERNAME, PASSWORD

to say “Welcome Digitalosophy” use the something like this

```php

<% name=Request.Form("USERNAME") %>
<%=("name") %> 'shortcut for
<% Response.Write("name") %>

```

---

<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:** [August 6, 2003, 12:35am UTC](https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639/3 "2003-08-06T00:35:15Z")

</div>

this is in the asp…yea…(im using notepad) …but how abt the flash codes… ? i currently trying to figure out previous examples…

---

<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:** [August 6, 2003, 12:36am UTC](https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639/4 "2003-08-06T00:36:38Z")

</div>

what?

> **im looking for is a code which allows me to check the information without using the flash application**

???

---

<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:** [August 6, 2003, 1:25am UTC](https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639/5 "2003-08-06T01:25:25Z")

</div>

ohh… got missed up there… what i meant was… check the information without using flash application as the reference…ya know when u add “trace” it will display the output in flash…what i was looking for , is a code which will display the output which is e.g “welcome to starworld” either by popping out a screen or just displaying it on the browser…

---

<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:** [August 6, 2003, 1:26am UTC](https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639/6 "2003-08-06T01:26:39Z")

</div>

sorry for the vagueness… 🙂

---

<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:** [August 6, 2003, 2:31am UTC](https://forum.kirupa.com/t/fetching-information-from-microsoft-access-to-flash-with-asp-with-asp/27639/7 "2003-08-06T02:31:18Z")

</div>

well you can display it on the browser a number of ways, either way you need some server side script to send that info to the browser. i would say the easiest way is

```php

<%= myVar %>

```

in you case you will need to pull the data from the asp script

```php

<% 
   un=request("un")
   Response.Write ("un") %>

```

that will output the users name to the browser.

you can pass that var to flash if u’d like and load the vars(AS) and print them