Using Access 2000 DB, Vb.net 2003, creating a oleDbDataAdapter to connect to a table within the Access DB.
This is the error message
"IErrorInfo.GetDescription failed with E_FAIL(0x80004005)"
Have done enough research on internet, and problem solving to figure out that it's because I'm using Zone (a reserved word) as a field/column within the table in question. However when I replace Zone with [Zone] in the select statement with the dataadapter wizard, it still gives same error.
Furthermore, when I take out Zone and leave all other fields in, it works fine.
Don't want to rename field in Db since this would effect many other iteracting queries that reference Zone in their queries