ahmed021399
asked on
DBGrid doesn't work
Why is that DBGrid do not work with ADO data control. I have DBGrid with SP3 and VB6 with SP4 and Access 2000. I need help urgently. Please help!! anybody!!
(I get the message no compatible data source found.)
ADODC connection i use as follows:
Provider=Microsoft.Jet.OLE DB.4.0;Dat a Source=C:\NewPos\NewPos.md b;Persist Security Info=False
(I get the message no compatible data source found.)
ADODC connection i use as follows:
Provider=Microsoft.Jet.OLE
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>You will NOT get any answer that will enable you to use the DBGrid with any form of ADO recordset.
Tim is right
I would suggest stick to ADO, but opt for another grid
Tim is right
I would suggest stick to ADO, but opt for another grid
Indeed that would be my preference but for some reason ahmed may prefer DAO and the DBGrid instead.
Was just thinking about .NET and the future
I agree entirely, I abandoned DAO pretty much as soon as ADO 2.0 came out and haven't touched it since except to deal with problems here and on similar forums. ADO.NET may not be identical to ADO but it is certainly more similar than DAO so would be a logical step. However there is no accounting for personal taste.
you can use the dbgrid with ADO or with any kind of data for that matter
just use it in unbound mode
as for DAO versus ADO
i love ADO wonderfully flexible
but i never use it against an access db
againts an access db DAO is magnitudes faster then ADO
just use it in unbound mode
as for DAO versus ADO
i love ADO wonderfully flexible
but i never use it against an access db
againts an access db DAO is magnitudes faster then ADO
btw it is not an either/or situation you can use both ADO and DAO in the same project
oops forgot to look at your grading record
PLEASE do NOT accept my comments as an answer
PLEASE do NOT accept my comments as an answer
Oh not a good grading record indeed ahmed!
ASKER
Hope this would make me a good grader.
Well it is indeed a start ahmed.
ASKER