Please help with this Error:

[JFB]

Hi,
I have an error when I fill the dataadapter with :
Me.OleDbDataAdapter1.Fill(Me.DataSet11)

Here is the error:

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred
in system.data.dll

What is the problem?
Tks
JFB

 

[William Ryan eMVP]

JFB:

Could be many things...
First, check if you can open the connection the DataAdapter's command object
is using.... and verify that it can open the connection. Similarly,
wrap the fill command in something like

Try

Catch ex as OleDbException
Debug.Assert(false, ex.ToString())
End Try...

See if that doesn't give you some more information
NExt, verify your SQL Statement and make sure you don't have any reserved
words in it like 'Date' for instance. I've seen this a lot with Access and
people using reserved words as field names.

Then make sure all the object names are spelled correctly, you have
permissions, etc.

I'm guessing it's a reserved word though....HTH,

Bill

 

[JFB]

Tks for you reply William .... it was the user permission.
JFB