Retreiving data from MS ACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using VB.NET to retrieve data from an ACCESS database. I tried using an
oledb data reader as well as an oledb data adapter to retrieve data from the
tables within this database. Everything works fine for all tables except one.
I get an oledb exception when i try even a simple query such as
"Select * from MyTable"....does anyone know why this could be? Why does
my OLEDB connection work fine with all other data tables except this one?
The only thing that I noticed is that this table has more fields and columns
than any of the others table...could this be a factor?

Any advice or clue is greatly appreciated

Parvee
 
How many columns does it have?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Hi Parveen,

Are any of the columns either reserved words or two words per column (eg,
account number)? Show us a full list of the columns and their names, but,
no, no amount of columns will cause an exception, so far as I know.

Bernie Yaeger
 
The table has 33 columns but none of the names are key words...
and none use two words for the name..

This is the error message that I receive

IErrorInfo.GetDescription failed with E_FAIL(0x80004005

No idea what's going on....
 
Back
Top