Edit this page

Binding to Access DB(Tips and Tricks)

Issue 1: Creating a DataSet from MS Access

When you create a dataset from the MS Access database, several properties of the auto number fields are wrongly set. Please, set these as in the right (correct) version below:

Issue 2: Updating and Synchronization of DataSets

Access databases have to be treated slightly differently than SQL data bases, because the dataset is not created correctly when the data tables are created, which in turn will not update your data set correctly once a change in an appointment is done.

This is due to a synchronization problem between the database and the dataset, where the data adapter could not update correctly the Id of the added row. Please, review the following MSDN article on how to solve this limitation: Retrieving Identity or Autonumber Values

See Also