Connecting Access DB in VB.Net

[peggyk2]

I am extremely new to vb.net. I'm trying to connect an Access Database using the OleDBDataAdapter Wizard and everytime I try to Finish after generating the SQL statement, I get the following errors depending on which table I am trying to load.
"Could not determine which columns uniquely identify the rows" and "The original query has a select list that has columns from multiple tables. The statement cannot be generated automatically for this type of query." These statements appear under the Update and Delete and the Insert, Update, and Delete Statements, respectively. What do these mean and what can I do to get around the problem?

 

[bobalston]

I get the same thing. ODBC accessing an Access 2003 database. The table does have a primary key defined in Access, an autonumber field.

Suggestions?

Bob

 

[paulrw1]

peggk2 - sounds like your OLEDataAdapter thinks you are using multiple tables. And in those tables are column names that are the same in 2 or more tables. You need to append the name of the table in front of each column name (ex.: mytablename.fieldname)

 

[zemp]

This may be better received in the VB.Net forum. Try forum796.

zemp