Printable View
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
set datagrid1.datasource = rd
<center>
<HR width=80%>
<img src='http://web.tiscali.it/bertaplanet/im...ertaplanet.gif'>
</center>
this is giving me an error
type mismatch
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>
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
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>
ms datagrid control 6.0 (oledb)
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>
i have databound grid 5.0(sp3)
will this work
i have databound grid 5.0(sp3)
and that is giving me an error
class doesnot support automation or doesnot supported expeceted interface
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>
Try assigning Recordset to the Datagrid data source property
I think you should say datagrid1.datasource = rd
nope it is not working