Loading data into a Data grid

[claws2rip]

I'm using VB 6 front-end with MS Access 2000 back-end.

using an ADO recordset, i'm attempting to load data from a recordset to a data grid, however i keep on getting an error message "Cannot initialize data bindings" when i use the "datagrid.rebind" method. if i remove the rebind method then the data grid remiains empty. this is occuring on my development machine.

At the same time, in a different application (using Vb front-end and Sql server back-end) i can load data into the data grid without any problems.....

any help would be greatly appreciated

Sam

 

[FRoeCassNet]

Sounds like a problem trying to bind the grid to the datasource. Can you do this binding to the Access DB successfully in design mode?

 

[claws2rip]

I havent tried binding the grid in MS Access, since the users will only be using the Vb front-end, however, i think i found the problem...it was with my ODBC connection, turns out there r 2 connections with an .mdb extension. it works when i used the "driver do Microsoft Access (.mdb)" and not "MS Access driver (.mdb)"

Sam