1. Application adodc1 controls, connection MDB files, execute:
Adodc1. You. Close 'Close you object
Adodc1. The ConnectionString=""
Adodc1. RecordSource=""
The Set Adodc1. You=Nothing
Delete the object,

2 rejoin the MDB file:
Cn1. The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0; Persist Security Info=False; Data Source="& amp; 2. The MDB
Adodc1. The ConnectionString=Cn1
Adodc1. RecordSource="" Select * From... "

Adodc1 control list of parameter setting, unable to retain?
The principle of how? Control is how to load?
Request master answer

CodePudding user response:

Adodc1. The ConnectionString=Cn1
It can draw=?

CodePudding user response:

Can
Dim Cn1 As New ADODB. Connection
I want to know is to remove in-memory object after the ADODC load again, why the control parameter Settings are invalid, the process is

CodePudding user response:

ADODB. Connection to open should not affect ADODC Settings

You should close the ADODB library. The Connection, you are secondary,

If the new database structure changed may