Access Database problem

[Willie]

Greeings all,
I am unable to complete adding a Data Adapter to my application in VB .net.
1) I drag the adapter on to the form,
2) I select 'New Connection,' connect to the database table using Jet 4.0,
then test connection....to this point I am good.
3) Next Page, I use SQL Statements
4) I use the Query Builder, select the table I need, then click next...
5) Then I get the following error message:

The wizard detected the following problems when configuring the data adapter
"OleDbDataAdapter1"
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Does anyone recognize this problem? It's probably something silly that I'm
doing wrong. I have tried to follow several different methods of connecting
using tutorials but always get to this point with this same message.

 

[Roger Rabbit]

Whats the name of the table you are trying to connect too? Have you used a
keyword for the table name?
Can you connect to another table or have you just banged your head against
this one repeatedly?

RR

 

[Willie]

Thanks for responding.
I was trying to connect to my tblCode and yes, banged my head repeatedly
with it. I just tried connecting to another table in the db called Category
and it went through fine. Hmmmm.

Do you think it may be the table name? Or maybe something is corrupt in
that table?

 

[Roger Rabbit]

No tblCode is not an Access/Jet/Sql Keyword but the fact that its fine with
another table says (more than likely) that its table specific and therefore
you needn't have tried the several different methods of connecting.

Next step would be to look at column names in the table schema. Are any of
those keywords?

RR