ADO Connection to Access Database Failure

[FalconBLUE]

Hi experts

I have code as below and trying to connect password protected Access database in company network. Every line is perfect work untill the open line. When it comes to open line, waiting and giving "" (empty) result. I couldn't understand why? If you have any idea, can you share me please?

    Set AdoCN = New ADODB.Connection
    AdoCN.Provider = "Microsoft.ACE.OLEDB.12.0"
    AdoCN.Properties("Jet OLEDB:Database Password") = "562Tamam!"
    AdoCN.ConnectionString = UserDB.txtLink

    AdoCN.Open

 

[FalconBLUE]

I tried copy the access file to desktop but result is same.

Hi experts

I have code as below and trying to connect password protected Access database in company network. Every line is perfect work untill the open line. When it comes to open line, waiting and giving "" (empty) result. I couldn't understand why? If you have any idea, can you share me please?

    Set AdoCN = New ADODB.Connection
    AdoCN.Provider = "Microsoft.ACE.OLEDB.12.0"
    AdoCN.Properties("Jet OLEDB:Database Password") = "562Tamam!"
    AdoCN.ConnectionString = UserDB.txtLink

    AdoCN.Open