Script ASP untuk koneksi Database

• connection.asp (untuk MS Access 2003)

<%
dim connection
Set connection = Server.CreateObject("ADODB.Connection")
connection.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
& server.MapPath("coba.mdb") & ";Persist Security Info=False"
%>

• connection.asp (untuk MS Access 2007)

<%
dim connection
Set connection = Server.CreateObject("ADODB.Connection")
connection.open"Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\myFolder\myAccess2007file.accdb;Persist Security
Info=False;"
%>

• connection.asp (untuk MS Access 2010)

<%
dim connection
Set connection = Server.CreateObject("ADODB.Connection")
connection.open"Provider=Microsoft.ACE.OLEDB.14.0;Data
Source=C:\myFolder\myAccess2010file.accdb;Persist Security
Info=False;"
%>

Keterangan : untuk myFoler itu diisi folder dimana anda meletakkan filenya, sedangkan untuk myAccess ....file.accdb itu nama file Access yang Anda simpan...
Selamat mencoba ......heheh