SQL connection string for microsoft access 2010 .accdb

by

For Acces databases (.mdb, .accdb, etc…), you want to use OleDbConnection, not SqlConnection (SQL Server), like this:

conn = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\BC207\test.accdb")

More Related Contents:

  1. Call the maximum from SQL table to textbox
  2. Store value in Yes/No field in Access using C#
  3. OLEDB Parameterized Query
  4. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine while data export to MS ACCESS
  5. How to insert a record into a access table using oledb?
  6. How to create Microsoft Access database in C# programmatically?
  7. Refresh button – Refreshing data grid view after inserting, deleting, updating
  8. Do we have transactions in MS-Access?
  9. Transitioning from Windows Forms to WPF
  10. Filtering DataGridView without changing datasource
  11. Redirect console output to textbox in separate program
  12. How can I close a login form and show the main form without my application closing?
  13. How can I customize the system menu of a Windows Form?
  14. Get the value for a listbox item by index
  15. SQL Insert Query Using C#
  16. how I can show the sum of in a datagridview column?
  17. C# DataGridView Checkbox checked event
  18. Accessing a form’s control from a separate thread
  19. SynchronizationContext.Current is null in Continuation on the main UI thread
  20. Adding Text to DataGridView Row Header
  21. Changing the color of the title bar in WinForm
  22. Force to close MessageBox programmatically
  23. Resize Controls with Form Resize
  24. Change language at runtime in C# winform
  25. Process.Start(url) fails
  26. How to use String property as primary key in Entity Framework
  27. Winforms : How to bind the Checkbox item of a CheckedListBox with databinding
  28. Passing object to different windows forms
  29. Winforms : Intercepting Mouse Event on Main Form first, not on Controls
  30. Why does text drawn on a panel disappear?

Leave a Comment