Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    5

    Exclamation Unanswered: How to post form data to Access Database

    Hi I am new to web databases..Can anyone help me how to insert form data to access database as a backend...
    I ahve a simple form for the users to register. Want to know in detail how do we connect ...ODBC connectivity, and other things...Would be grateful fi anyone can help me in the steps...Or suggest any webssite which has complete steps to complete the task...

    Thanks in advance
    Banu

  2. #2
    Join Date
    Jul 2003
    Posts
    48

    Re: How to post form data to Access Database

    This uses the actual path location to your database on the web server

    strSQL="SELECT * FROM Table1" 'This could be an insert into statement
    set cn = server.createobject("ADODB.Connection")
    set rst = server.createobject("ADODB.Recordset")
    cn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=c:\database\Test.mdb"
    set rst = cn.execute(strSQL) 'Return recordset or cn.execute(strSQL) to execute a SQL statement that returns no records

  3. #3
    Join Date
    Jul 2003
    Posts
    5

    Re: How to post form data to Access Database

    Thanks for that but if u give me this i am lost..Actually i am doing this thru Dreamweaver...So I need to know the complete step by step process...AS i have already told...i am very new to this ...I only know taht i have a form and this data can be collected on to a access database...SO is there atleast a website where i can get the info in step by step.....



    Originally posted by bscorer
    This uses the actual path location to your database on the web server

    strSQL="SELECT * FROM Table1" 'This could be an insert into statement
    set cn = server.createobject("ADODB.Connection")
    set rst = server.createobject("ADODB.Recordset")
    cn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=c:\database\Test.mdb"
    set rst = cn.execute(strSQL) 'Return recordset or cn.execute(strSQL) to execute a SQL statement that returns no records

  4. #4
    Join Date
    Jul 2003
    Posts
    48

    Re: How to post form data to Access Database

    Visit http://www.codeave.com/index.asp they have loads of example scripts. You will need to have a web server running to process the asp web page.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •