Unable to Update Data table in Access Database via ADO

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Here is exactly what I am trying to accomplish: I have my information stored
in a Microsoft Access Database and I am using Microsoft Visual Studio 2003 to
build a front end to gain access to the database.

Step 1: I used the OleDbConnection to create a connection to the
Database (conProjectAllProjectFields)

Step 2 : I used the OleDbDataAdapter to create a data adapter
(oledataadaAllProject) and wrote a querywithin the adapter query window
(Select * from Project)

Step 3 : I created a data set (dsAllProject)

Step 4: I then created some text boxes to represent each field

Step 5: I then bind each text box to the data set via the Binding-Text
property of the text box.


Clear and Fill the data set
------------------------------

dsAllProject.Clear()
oledataadaAllProject.Fill(dsAllProject)

ACCEPT THE CHANGES
----------------------------------
oledataadaAllProject.Update(dsAllProject, "PROJECT")
dsAllProject.PROJECT.AcceptChanges()



After all that the modified data does not gets pushed to the taable

Thenks a million

.