Ok, I am trying to create a front end for an access db. I have tried using my database and MS' northwinds sample database exercise. I'm using VB Express aswell have tried in Visual Studio 2005, same error.

I have connected to the database, added the db as a data source, selected the tables I want and dragged the table to the form. However, when I run it I am just displayed with a blank datasheet, however with the correct columns and names. If I preview the data in the data sources section it does retrieve the data - why isn't it getting it when I run it then?

I do notice as soon as I run, the database connection icon changes to the close one and I get such error -

A first chance exception of type 'System.InvalidOperationException' occurred in System.Data.dll

Any help would be really appreciated