Re: Database Access with Dreamweaver

When creating a database link in Dreamweaver to ensure that the test server has a host directory / web, or you will get errors that Dreamweaver is trying to create files in the wrong folder.

Re: Database Access with Dreamweaver

why not just use MYSQL query browser, Dreamweaver is notoriously buggy and cumbersome for these things.

Re: Database Access with Dreamweaver

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
=============