Connect to Protected 2007 MS Access Database mdb file

[FalconBLUE]

Hi everyone,

I have userform and transferring some data to closed excel files. This data collecting in MS Access mdb database and I want to protect this. I found a string from the net and I connect unprotected my mdb file successful. These codes are below but I don't know how can I connect my mdb file when I protect? How can I modify these codes?


Set AdoCN = CreateObject("ADODB.Connection")
File_Path = "C:\Shared\Ware\2017\Stocks.mdb"
AdoCN.Provider = "Microsoft.Jet.OLEDB.4.0"
AdoCN.ConnectionString = Dosya_Path
AdoCN.Open

 

[FalconBLUE]

I took support from another Excel Expert. The codes is changed below;

Set AdoCN = CreateObject("ADODB.Connection")
File_Path = "C:\Shared\Ware\2017\Stocks.mdb"
AdoCN.Provider = "Microsoft.Jet.OLEDB.4.0"
AdoCN.Properties("Jet OLEDB:Database Password") = "???"
AdoCN.ConnectionString = File_Path
AdoCN.Open