# Flash, asp, and access database

**URL:** <https://forum.kirupa.com/t/flash-asp-and-access-database/324990>\
**Category:** flash\
**Created:** [September 20, 2011, 1:39pm UTC](https://forum.kirupa.com/t/flash-asp-and-access-database/324990 "2011-09-20T13:39:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![wfz](https://avatars.discourse-cdn.com/v4/letter/w/65b543/32.png) [@wfz](https://forum.kirupa.com/u/wfz)\
**Post date:** [September 20, 2011, 1:39pm UTC](https://forum.kirupa.com/t/flash-asp-and-access-database/324990/1 "2011-09-20T13:39:03Z")

</div>

[http://www.kirupa.com/developer/actionscript/forms\_database.htm](http://www.kirupa.com/developer/actionscript/forms_database.htm)

I got partial success with the tutorial above, but couldn’t figure out a few things.

1. How to save the date and time to the database? Based on web search result on how to find date or time in APS, I thought I could do  
[COLOR=#ff0000]theDate = \<%=date()%\>  
theTime = \<%=time()%\>  
[/COLOR]add the fields in MDB and modify the line

SQL = “INSERT INTO contacts (FirstName, LastName, Email, Message, Date, Time) VALUES (’”&strFirst&"’,’"&strLast&"’,’"&strEmail&"’,’"&strMessage&"’,’"&theDate&"’,’"&theTime&"’)"  
conn.Execute(SQL)

but the ASP generated errors on the 2 lines.

1. When executing the file (getURL(“[http://yourSite.com/processForm.asp",0,"post](http://yoursite.com/processForm.asp%22,0,%22post)”);  
}), it always opens the processForm.asp file in a new window. Can it be executed in the same window or just being hidden?

The tutorial is old, and I wonder if there are new ways to do the things with CS4 or CS5?

Thanks for the help,