BindingNavigator update

[Joejoe79sa]

Good day... I am a beginner at this so please bare with me. I am doing a small app that connects to Access database and using the Binding navigator i can brows my records etc. My problem is to commit changes i made to the database. I add new records and can brows them but they do not commit to the database. Any idea how i can commit my changes?

 

[Joejoe79sa]

Answer

Well i found a answer that goes like this " In the solution explorer select your database and set the property 'Copy to Output Directory' to 'copy if newe'r or 'never copy'.

Reason: Everytime you build your project the database you use in the development environment is copied to the output directory, thus overwriting the database used in run time.

What you can do as well:

Next time when asked to copy the database to the application folder simply answer no (when creating a new connection)."

But i dont have that property.... Where do i find it?

Thanks

 

[cjard]

read the DNU link in my signature

 

[Arg81]

Request for your DNU post to be made a sticky in the Data Access forum!!!

 

[cjard]

Its already sticky in ADO.NET i think.. or maybe articles of interest. I dunno. It was sticky for a while, somewhere