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”
cnn.Open

Debug.Print cnn.State = adStateOpen

cnn.Close

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”

cnn.Close

Categories: Classic ASP | Tinggalkan komentar

Navigasi pos

Tinggalkan Balasan

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

Logo WordPress.com

You are commenting using your WordPress.com 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

Buat situs web atau blog gratis di WordPress.com.

%d blogger menyukai ini: