Suddenly all before, tip error: object variable or variables with block is not set,
Dim gcnERmis As New ADODB. Connection
With gcnPRmis
The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0; The Data Source=d: \ 1. MDB. Mode=ReadWrite | Share Deny None; Persist Security Info=False; The Jet OLEDB: Database Password=123456
". The Provider="sqloledb"
. Open
End With

CodePudding user response:

Dim gcnERmis As New ADODB. Connection
With gcnERmis
The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0; The Data Source=d: \ 1. MDB. Mode=ReadWrite | Share Deny None; Persist Security Info=False; The Jet OLEDB: Database Password=123456
". The Provider="sqloledb"
. Open
End With

CodePudding user response:

Check your project reference in the ADODB library version, choose into your list the highest version,