Non-web SQL Injection

by

If you’re building SQL in your macro, it’s vulnerable to SQL injection. Even if you trust the people who will be using the thing, you should at least watch for the basics, like people trying to put single-quote and semicolon characters into database fields. this isn’t so much a security issue in your case as just data validation.

More Related Contents:

  1. Trying to use variables as values vba to sql
  2. How to insert an embedded picture?
  3. Error: “Could Not Find Installable ISAM”
  4. Rounding in MS Access
  5. Get length of array?
  6. Comparison of Dictionary, Collections and Arrays
  7. How to query a MS-Access Table from MS-Excel (2010) using VBA
  8. What is the different between IsNull, IsEmpty, =Empty, and an empty string ie “” and why might I use variants
  9. Sequence of numbers based on start and end value of 2 cells [closed]
  10. Function to convert column number to letter?
  11. Better way to find last used row
  12. How to insert a picture into Excel at a specified cell position with VBA
  13. 2 Dimensional array from range [closed]
  14. Save multiple sheets to .pdf
  15. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  16. How can I create a calendar input in VBA Excel?
  17. Using Google Chrome in Selenium VBA (Installation Steps)
  18. Change date format using substitute or replace
  19. Concatenate cell data into another data if values matches
  20. Iterating through populated rows
  21. Using VBA to detect which decimal sign the computer is using
  22. Loop through each row of a range in Excel
  23. Fill formula down till last row in column
  24. Outputting Excel rows to a series of text files
  25. How to create a range from two ranges in VBA?
  26. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  27. If string contains word from list, return value adjacent to list value
  28. excel vba freeze pane without select
  29. Converting a string representation of a constant into a constant?
  30. How to get the range of the visible rows after applying an advanced filter in Excel (VBA)

Leave a Comment