Database dreamweaver to Ms Access?

I am trying to make a website, with HTML (dreamweaver) how can i connect my website using Database MS Access ( Dreamweaver and MS Access) please . thankyou.

If there is any coding how can i get it . thankyou

3 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Your database is on the server so you'll need a script to interact with the server, familiar name: server-side script, such as ASP or PHP and in this case you'll likely need ASP. And this is how to connect to MSAccess.

    ◘ Connect to a MS Access database using a DSN.

    ================ ====================== ==========

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

    oConn.Open "DSN=;UID=;PWD="

    oConn.Close

    ◘ Connect to a MS Access Database using DSN less OLEDB connection.

    ================= ================== ==============

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

    oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("") & ";" oConn.Close

    Set oConn = Nothing

    ◘ Connect to a MS Access database using DSN less ODBC connection.

    ===================== ================== =========

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

    oConn.Open "DRIVER={Microsoft Access Driver(*.mdb)};DBQ=" & Server.MapPath("") & ";UID=;PWD="

    oConn.Close

    Set oConn = Nothing

    note: Server.MapPath("") is your virtual path.

    Other useful links

    =============

    http://www.webwizguide.com/kb/asp_tutorials/connec...

    http://www.haneng.com/lessons_17.asp

    http://www.tutorialized.com/tutorial/How-to-connec...

    Good luck!

    K L U D G E

  • 4 years ago

    Dude, Frist Create a area for the record, record variety and finding out server. Then opt for Databases from utility portlet and persist with the guidance. you may make a call from rather some kinds of database types and get going. solid success!

  • Anonymous
    6 years ago

    Well

    Are you wondering how to downoad for free Dreamweaver? You can get it for free here http://bitly.com/1r4XNnn

    Give it a try.

    Cheers.

Still have questions? Get your answers by asking now.