Set DG.DataSource = Rs.DataSource err:
'-2147221504 (80040000)':

ADO needs to be installed to use DataBinding

Code:
Private Sub UpdateDataGrid(DG As DataGrid, SQL As String)
  Set DG.DataSource = Nothing
  Set Rs = Cnn.OpenRecordset(SQL)
  MsgBox Rs.RecordCount
  Set DG.DataSource = Rs.DataSource
  
End Sub