Link to home
Start Free TrialLog in
Avatar of ahmed021399
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.OLEDB.4.0;Data Source=C:\NewPos\NewPos.mdb;Persist Security Info=False
Avatar of ahmed021399
ahmed021399

ASKER

For any more clarifications please ask.
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>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
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
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
Oh not a good grading record indeed ahmed!
Hope this would make me a good grader.
Well it is indeed a start ahmed.