Displaying data of an Access database in a Datagrid

Any help would be much appreciated... The problem I have is my Datagrid used to be able to display the data of an Access file, but not anymore.

I've recently wanted to modify a program I wrote a few months ago (with VB6). In the form, there is a Datagrid, of which the DataSource is an ADODC that is linked to an Access file. No code was written for this connection, and the data of the Acces file used to display in the Datagrid during run time.

Now, after a few months, for some reasons, the data is not displayed anymore. I can make the Datagrid to display the column titles by clicking 'Retrieve Fields'. So I guess it means that the Datagrid can read the Access file, but just 'doesn't want to' display the data!

I've also tried to use MSFlexgrid and DataEnvironment Object, but the result is the same.

I'm very puzzled. Someone has suggested that it may be that some Windows Update broke the function, so I should make sure I've all the latest updates, in case the broken function is fixed. I've tried that, but no use.

I'd be really grateful for some advice, or even guesses. Thank you.

[1116 byte] By [Wing_VB6] at [2007-12-16]
# 1
Hi Wing_VB6,

Please post this on the Microsoft Newsgroups which has several groups for VB6. This forum is for Visual Basic 2005 posts only.

Regards,
Vikram

Vikram at 2007-9-9 > top of Msdn Tech,Visual Basic,Visual Basic General...