Opening a database using ASP and button

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Opening a database using ASP and button

Logged in as: Guest

arrSession:exec spGetSession 2,3,786

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Opening a database using ASP and button
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Opening a database using ASP and button - 2/24/2003 10:48:44 AM

Portmoon

Posts: 4
Score: 0
Joined: 2/24/2003
From:
Status: offline

Hi I am trying open a database (MS Access) via an ASP.

It is a simple page with two options one link to enter the
site and the other that will allow the database administrator
access to the raw tables and records within. If possible I would like it to open the 'Main Menu' form in the database??
I have included the database connection script below but don't know how to incorporate a button around it, nor the SQL that is needed to open the database.
Security is not an issue regarding access to the database
this is only for personal educational use only.

<%

Set Conn = Server.CreateObject("ADODB.Connection")Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("myDatabase.mdb") & ";pwd=myPassword"

set rs = Server.CreateObject("adodb.RecordSet")
rs.open "SELECT ???????

%>

Any guidance would be much appreciated!!

Thanks!!