Access OLEDB reports “syntax error” but the statement looks correct

by

PASSWORD is a reserved word in Access SQL so you need to enclose it in square brackets if it is a column name.

strSQL = "UPDATE users SET [Password] = '1'"

More Related Contents:

  1. ASP.NET “special” tags
  2. How to use gmail SMTP in ASP.NET form
  3. What is the best way to read/parse the XML files [closed]
  4. Accessing Session Using ASP.NET Web API
  5. SignalR – Sending a message to a specific user using (IUserIdProvider) *NEW 2.0.0*
  6. What is the App_Data folder used for in Visual Studio?
  7. CodeFile vs CodeBehind
  8. How to update a PDF without creating a new PDF?
  9. Adding ASP.NET MVC5 Identity Authentication to an existing project
  10. ASP.NET web.config: configSource vs. file attributes
  11. How serious is this new ASP.NET security vulnerability and how can I workaround it?
  12. How do I protect static files with ASP.NET form authentication on IIS 7.5?
  13. asp.net validation to make sure textbox has integer values
  14. ASP.Net Download file to client browser
  15. ASP.NET Custom user control to add dynamically
  16. EditorTemplate for DropDownList
  17. Capturing SOAP requests to an ASP.NET ASMX web service
  18. Caching specific Javascript and CSS files
  19. Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control
  20. Get DisplayName Attribute without using LabelFor Helper in asp.net MVC
  21. Can I get the browser time zone in ASP.NET or do I have to rely on JS operations to retrieve the information?
  22. Specifying maxlength for multiline textbox
  23. How to return a view for HttpNotFound() in ASP.Net MVC 3?
  24. Web API Queryable – how to apply AutoMapper?
  25. ViewModel’s list is null in action
  26. Disable the postback on an
  27. How to use Castle Windsor with ASP.Net web forms?
  28. HttpCookieCollection.Add vs HttpCookieCollection.Set – Does the Request.Cookies collection get copied to the Response.Cookies collection?
  29. Button click not working inside update panel
  30. Is there a recommended way to return an image using ASP.NET Web API

Leave a Comment