Primary Key in Access not loaded into Dataset
Posted on 2003-11-28
Hoping you can help me with a Primary Key issue with VB .NET and Access. I've set up a simple Access database and defined a Primary Key for one of the columns. I've no problems connecting to Access and loading the table in question into a dataset however it seems to lose or not load any PK's. There's no complexity to the database its just one table with no relations [i'm getting stuff to work before things get convoluted].
As a consequence commandbuilder builds incorrect SQL commands as i get 'INSERT INTO' errors when trying to use update. As the DB is going to stay reasonably simple i'd like to keep commandbuider for its flexability.
I'm hoping that this has cropped up before and any advice or insights would be much appreciated. Many thanks in advance.