I'm trying to switch over from using the ADO control in my project to creating the ADO recordsets purely in code.

So I'm trying to link such a recordset, created from code, to my controls, namely an MSChart and a DataGrid:

dbRecordset.Open ("SELECT Quantity FROM Table1"), dbConnection

(recordset & connection variables are already defined)

Set MSChart1.DataSource = dbRecordset
Set Datagrid1.DataSource = dbRecordset

Problem #1: My MSChart shows up _completely_ blank. I mean not even the axes or anything shows up.

Problem #2: My DataGrid slaps me with an error saying "Error 7004 - The rowset is not bookmarkable"


What am I doing wrong?