Access SQL syntax error when using OleDbCommandBuilder

by

Try this:

Immediately after the line

var builder = new OleDbCommandBuilder(dbAdapter);

add the two lines

builder.QuotePrefix = "[";
builder.QuoteSuffix = "]";

That will tell the OleDbCommandBuilder to wrap table and column names in square brackets, producing an INSERT command like

INSERT INTO [TableName] ...

instead of the default form

INSERT INTO TableName ...

The square brackets are required if any table or column names contain spaces or “funny” characters, or if they happen to be reserved words in Access SQL. (In your case, I suspect that your table has a column named [Password], and PASSWORD is a reserved word in Access SQL.)

More Related Contents:

  1. OleDbCommand parameters order and priority
  2. OLEDB Parameterized Query
  3. Trying to insert DateTime.Now into Date/Time field gives “Data type mismatch” error
  4. What’s wrong with these parameters?
  5. How to connect to a MS Access file (mdb) using C#?
  6. Store value in Yes/No field in Access using C#
  7. Using parameters inserting data into access database
  8. Writing large number of records (bulk insert) to Access in .NET/C#
  9. Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
  10. Reading excel file using OLEDB Data Provider
  11. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine while data export to MS ACCESS
  12. OleDbParameters and Parameter Names
  13. Parsing CSV using OleDb using C#
  14. What is IMEX within OLEDB connection strings?
  15. Convert Access image OLE Object into raw image byte array in C#
  16. Additional Setup in Visual Studio Installer Projects
  17. How to create an Access database at runtime in C#?
  18. Different LIKE behaviour between my application and the Access query wizard
  19. How to insert a record into a access table using oledb?
  20. How to create Microsoft Access database in C# programmatically?
  21. Is there a “proper” way to read CSV files [duplicate]
  22. Refresh button – Refreshing data grid view after inserting, deleting, updating
  23. How to insert an image into an Access OLE field via .NET
  24. Persist Security Info Property=true and Persist Security Info Property=false
  25. Retrieve List of Tables in MS Access File
  26. Scientific notation when importing from Excel in .Net
  27. SQL connection string for microsoft access 2010 .accdb
  28. Do we have transactions in MS-Access?
  29. When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
  30. Import Excel to Datagridview

Leave a Comment