PDA

Click to See Complete Forum and Search --> : hopefully easy


hyme
Sep 22nd, 2000, 10:04 AM
Howdy:

I have an ADO connection to an ACCESS97 db using a data control (the connection is fine)
I am trying to attach the datasource property of a MSFlexGrid to the data control.
I get the error:
"No compatable data source was found for this control. Please add an intrinsic Data Control. "

What am I missing? A Reference, a different Data Control?
Help!


Thanx

JHausmann
Sep 22nd, 2000, 11:10 AM
Hey, I don't use data controls but I think ADO has a different datacontrol than DAO.

666539
Sep 22nd, 2000, 12:29 PM
There are some data controls that can be used with ADO and some that can be used with DAO. There are several grids that come with VB. There are 2 plain grids, one that works with ado and that works with dao. I'm not sure if the same thing applies to the flex grid.

P.S.W.
Sep 22nd, 2000, 01:39 PM
The grids work like this:

DAO compatible:
1. DBGrid
2. MS FlexGrid

ADO compatible:
1. DataGrid
2. MS HFlexGrid (Hierarchical FlexGrid)

To solve your problem, it looks like you need to look in the components list for the MSHFlexGrid and use that instead of the regular MSFlexGrid (or you can use DAO instead of ADO).