i am working on vb and ado 2.1 with access 2000.<BR>whenever i use the following code, i don&#039;t get any results.<BR> con.provider = "Microsoft.Jet.OLEDB.4.0"<BR> con.open app.path & "database.mdb"<BR><BR> With rstdet<BR> Set .ActiveConnection = con<BR> .CursorType = adOpenKeyset<BR> .LockType = adLockBatchOptimistic<BR> .Open "select * from table"<BR> End With<BR> <BR> Set Adodc1.Recordset = rstdet<BR><BR>when i assign this adodc object to datagrid, the grid does not show any details. the table contains enough records.<BR><BR>whether the ado is complaint to access the ms access 2000 tables.<BR><BR>if i use jet.oledb.3.51 with access 97 tables, the same code works.<BR><BR>pls help me.<BR><BR>