Data Grid

[urs]

Set db = DAO.Workspaces(0).OpenDatabase(App.Path & "\Database1.mdb")
Set rd = db.OpenRecordset("Worker", dbOpenDynaset)


till here it is working fine it is getting connected to Access 2000 database
now i have DataGrid on my form when i try this code
datagrid1.datasource = db
it gives me and error method or data member not found
what is the problem
plzz help

[berta]

set datagrid1.datasource = rd




<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>

[urs]

this is giving me an error
type mismatch

[berta]

yes.. i thin u must use ADO insted of DAO...
I think dbgrid.datasource wants a ADODB.recordset...

hi,brt

<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>

[urs]

i am not getting Adodb
i even added Ado refrence it is showing me missing i dont know what is this problem that is y i use dao
if i use adodc1 then i wont b able to databse with the password

[berta]

R U using a MS DBGrid Control or a MS Data Bound Grid Control?



<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>

[urs]

ms datagrid control 6.0 (oledb)

[berta]

oledb means ADO...

so U try using a MS data bound control grid 5.0




<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>

[urs]

i have databound grid 5.0(sp3)
will this work

[urs]

i have databound grid 5.0(sp3)
and that is giving me an error
class doesnot support automation or doesnot supported expeceted interface

[berta]

U must use a DAO data control.
then at design time set datasourse of dbgrid to your dao data control( using combo)..



<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>

[shahp]

Try assigning Recordset to the Datagrid data source property
I think you should say datagrid1.datasource = rd

[urs]

nope it is not working