Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Connecting Access database to a web interface in VB 6.0

Hey Guys,

I have an access 2000 database and i would like to update it over the web.(Add,Delete records). Can you let me know what options I can go with and where I may find resources that will allow it to happen.............

Thanks
Newbie Chris

Comments

  • dre609dre609 Member Posts: 1
    : Hey Guys,
    :
    : I have an access 2000 database and i would like to update it over the web.(Add,Delete records). Can you let me know what options I can go with and where I may find resources that will allow it to happen.............
    :
    : Thanks
    : Newbie Chris
    :
    I would recommend using ASP to connect to your database. You can use Microsoft Frontpage or even notepad to accomplish this. Here is some sample code:
    <%@Language=VBScript%>;




    <%
    Dim db
    Dim cn
    Dim rs
    Dim strSql

    db = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Your Database Location;Persist Security Info=False"
    set cn = Server.CreateObject("ADODB.Connection")
    set rs = server.CreateObject("adodb.recordset")
    cn.open db

    sqlstr = "select * from Table"
    rs.open sqlstr,cn,1,2
    if not rs.eof then
    rs.movefirst

    %>



Sign In or Register to comment.