You are welcome buddy. Do write back.

Ankur

So I think I've tracked down the root of the whole problem. When you add the access file as a data source to your project, Visual Studio asks you if you want to copy the database file into your project workspace. If you answer "yes" to this, VS gives you a fresh copy of the data base to work with every time you run the project. Your changes are being propagated back to the Access db, but it's saving to the copy in your bin directory. Since that DB gets overwritten every time, you can't see the changes unless you manually start the application yourself by clicking on the icon in the bin directory (as opposed to launching it from visual studio).
Since the book's example is with a SQL database, it doesn't mention the dialog that happens when you use a database file on the local machine.

Ankur,

I have the same problem, but I am not using Access, rather I am using SQL Server 2005 with the *.dbo extension.

I am hoping that maybe you can help me resolve my problem as well.

I am using Window 2000 Server w/Sp 4 and all the latest updates.

Thanks in advance for your response.

Preston_JB

Dear Ankur, I'm facing the same problem like wb8bgy and preston_jb. Could you send me email of the sample code to my email address : [email protected]. I really frustated with this situation. Thanx in advance.

Hi Ankur, I also have the sam prob, I use MSSQL2005 express. Please send the same code to my e-address: [email protected]
Thanks in advance.

PS: I can update my databases by using sqlDataAdapter control, but using code failed.
Could you send me email?
Thanks.

Thank you for this posting!! This saved me some development time and headache tonight.

Poem to my ears. Glad to know it was of use to you.

Regards
Ankur