I have a form that I'm currently trying to bind with a access
database(which contains to tables). I used the OleDataAdapter to
obtain my OleDbConnections between my form and the two tables in the database. I gotten the first table in my database to generate a dataset for my form. But when I try to generate a dataset for the second table in my database, I received this error message Retrieving the schema for OleDbAdapter2 failed. Unspecified error: E_FAIL(0x80004005)

Any Advise on how to solve this error is greatly welcome. Thanks!

Hi Si,
I came across your message and I found it works for me. I connected to access and select 5 tables --> 5 datasets by coding ... NOT WIZZARD...
************************************************** ***
'from FormLogin::::
'********************
Public Shared dsScreen1, dsScreen2, dsScreen3, dsScreen4, dsScreen5 As New DataSet
    Public Shared WithEvents bmb As BindingManagerBase
    Public Shared daScreen1, daScreen2, daScreen3, daScreen4, daScreen5 As New OleDbDataAdapter
    Public Shared DRScnn As New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Directory.GetCurrentDirectory & "\" & "DRS.mdb")
'********************
'from Form1:::: use OleDbCommandBuilder
'********************
Public Shared cmdbuilder1 As New OleDbCommandBuilder(FrmLoginShare.daScreen1)
    Public Shared cmdbuilder2 As New OleDbCommandBuilder(FrmLoginShare.daScreen2)
    Public Shared cmdbuilder3 As New OleDbCommandBuilder(FrmLoginShare.daScreen3)
    Public Shared cmdbuilder4 As New OleDbCommandBuilder(FrmLoginShare.daScreen4)
    Public Shared cmdbuilder5 As New OleDbCommandBuilder(FrmLoginShare.daScreen5)
'********************
'then fill the dataset
'********************
FrmLoginShare.DRScnn.Open()
        FrmLoginShare.daScreen1.SelectCommand = New OleDbCommand("select * from screen1 where RecordID = (select Max(RecordID) from screen1)", FrmLoginShare.DRScnn)
        FrmLoginShare.daScreen1.FillSchema(FrmLoginShare.d sScreen1, SchemaType.Source, "Screen1")
        FrmLoginShare.daScreen1.Fill(FrmLoginShare.dsScree n1, "Screen1")
************************************************** ***
let me know if it helps or u can contact me at "[email protected]" Good luck.