The code below, in the ACCESS to connect to the ORACLE and gain success you record Set, but will record Set binding (Set Me. You=RSS) to ACCESS the form errors, prompt "in the corresponding item cannot be found in the collection of the name or ordinal", why? (note: binding SQL SERVER and ACCESS the data source when no problem)
Error:
Code:

 Private Sub Form_Load () 
Dim CNN As Object 
Dim RSS As Object 

Set the CNN=CreateObject (" ADODB. Connection ") 
The Set of RSS=CreateObject (" ADODB. You ") 

CNN. Open "the Provider=msdaora; Data Source=PROD; User Id=ABC; Password=ABC123;" 
RSS. Open the "select * from TBL", CNN, 1, 1 

Set Me. You=RSS 

RSS. Close 
CNN. Close 
The Set of RSS=Nothing 
The Set of CNN=Nothing 
End Sub