Changes to Access database do not persist when running app in Visual Studio

by

It is a very common situation. You have your database file (the MDB or ACCDB file) listed between your project items. If you click on this file and look at the properties window you will see a property called Copy to the output directory. If this property is set to Copy Always then every time you start a debug session the database file listed in your project items is copied by VS in the output directory (usually BIN\DEBUG). Of course this copy doesn’t contain the records inserted in your last debug session and you think that your previous insert has failed.

Setting this property to Copy If Newer, the mentioned behavior will happen only if you change the database schema manually.

Setting this property to Copy Never, will let you manually copy the database file.

More Related Contents:

  1. Error ‘LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt’ after installing Visual Studio 2012 Release Preview
  2. UTF-8 without BOM
  3. How do you include additional files using VS2010 web deployment packages?
  4. IIS Express Windows Authentication
  5. Cannot import the keyfile ‘blah.pfx’ – error ‘The keyfile may be password protected’
  6. Targeting .NET Framework 4.5 via Visual Studio 2010
  7. NUnit isn’t running Visual Studio 2010 code
  8. How do I use MSTest without Visual Studio?
  9. No IntelliSense for C++/CLI in Visual Studio 2010?
  10. Restrictions on installing extensions or add-ins in Visual Studio 2010 Express
  11. How can I use PowerShell with the Visual Studio Command Prompt?
  12. Cannot connect to any online resource
  13. Can’t run ASP.NET MVC 2 web app on IIS 7.5
  14. How to fix “Root element is missing.” when doing a Visual Studio (VS) Build?
  15. Using CustomParameter with Visual Studio Multi-Project Template
  16. This project references NuGet package(s) that are missing on this computer
  17. Mercurial .hgignore for Visual Studio 2010 projects
  18. VS2010 and IE10 Attaching the Script debugger to process iexplore.exe failed
  19. MSBuild in TeamCity of Visual Studio 2012 solution
  20. After Publish event in Visual Studio
  21. How to make a tabbed window as in the picture using Visual C# (Studio 2010)
  22. I upgraded C++ projects from Visual Studio 2010 to 2015 still its showing Visual Studio (2010)
  23. Running two projects at once in Visual Studio
  24. How to support both vcxproj to cmake on a project?
  25. Localhost not working in chrome and firefox
  26. How to set SGEN toolpath in Msbuild to target 3.5 framework
  27. Static library debug symbols
  28. The type or namespace name ‘DbContext’ could not be found [closed]
  29. WPF C# InputBox
  30. Missing Project/Item Templates

Leave a Comment