ACCDB dengan Password [Classic ASP]

Dim strConnection As String
Dim cnn As ADODB.Connection

‘ Armansyah

strConnection = “Provider=Microsoft.ACE.OLEDB.12.0;” & _

Set cnn = New ADODB.Connection
cnn.ConnectionString = strConnection
cnn.Properties(“Jet OLEDB:Database Password”) = “test”

Debug.Print cnn.State = adStateOpen


Alternatif lain :

Dim cnn As New ADODB.Connection

cnn.Open “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Test Files\DatabasewPassword.accdb;Jet OLEDB:Database Password=’currentpassword’;Mode=Share Exclusive”

cnn.Execute “ALTER DATABASE PASSWORD newpassword currentpassword”


Categories: Classic ASP | Tinggalkan komentar

Navigasi pos

Tinggalkan Balasan

Please log in using one of these methods to post your comment:


You are commenting using your account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: