Hopefully a simple one ..

[Qaroven]

Hi all,
I've mainly worked on Access VBA before and now tinkering with VB. I'm using VB 5.0, and there's something I have yet to figure out how to do ..

On a form I would like to use a grid (rather than heaps of text boxes and paging) to show data from a database. It seems that in general the grid will only accept data objects for it's data source. I want it to connect to an Access 2000 DB but it can only handle an Access 97 DB. I woul much rather the connection stuff be done in code using ADO anyway, but is there any way to feed an ADO recordset from the form's code into the grid?
Ben
+61 403 395 052

 

[YoshiCD]

The simple track being, using Access 2000's Save As feature to save the DB as a A97 DB and a backup copy in A2000...

If is any help, mail me as this seemed to be the only way out for me..

¥oshi..

 

[Qaroven]

Hrm .. that sounds like giving up and using the data object tho? which I don't want to do Ben
+61 403 395 052