DAODB and Datagrid help

[choas]

I am using DAODBEngine to create and manipule database in my application, but I don't reach to fill a datagrid control with it. Here a exemple of my code :

Public recordset As DAO.Recordset
Public dbs As DAO.Database
 
dbs = DAODBEngine.OpenDatabase(locat)
recordset = dbs.OpenRecordset("SELECT * FROM DVD-ROM")
 
frmMain.DefInstance.DataGrid.DataSource = recordset

locat is the path of the database.


Thanks for your help