What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute

by

They do not both mask errors. DoCmd.SetWarnings masks errors and is system wide, not confined to the single application that you are using. DoCmd.SetWarnings False without the corresponding DoCmd.SetWarnings True will mean that action queries will run without any prompts in any Access application on the PC.

Execute does throw warnings, the warnings that you need, such as the query failed to execute, but does not give warnings you may not need, such as “Are you sure you want to run this query”.

In this thread Allen Browne, Access MVP, says he does not use Set Warnings.

As an aside, I would generally recommend using an instance of CurrentDB, as this will allow you to return a record count, amongst other things, so:

Set db = CurrentDB
db.Execute sSQL, dbFailOnError

More Related Contents:

  1. How do I use parameters in VBA in the different contexts in Microsoft Access?
  2. Using Excel VBA to export data to MS Access table
  3. How to use system username directly in MS Access query?
  4. Access – compare two tables and update or insert data in first table
  5. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  6. How to save the result of a SQL query into a variable in VBA?
  7. Escaping ‘ in Access SQL
  8. Managing and debugging SQL queries in MS Access
  9. SQL multiple join statement
  10. How do I write a full outer join query in access
  11. How to do INSERT into a table records extracted from another table
  12. Multiple INNER JOIN SQL ACCESS
  13. Performing SQL queries on an Excel Table within a Workbook with VBA Macro
  14. How to simulate UNPIVOT in Access?
  15. Table-less UNION query in MS Access (Jet/ACE)
  16. Ms Access Query: Concatenating Rows through a query
  17. is there a group_concat function in ms-access?
  18. Accessing SQL Database in Excel-VBA
  19. Excel function to make SQL-like queries on worksheet data?
  20. Automatically generating handling of issues
  21. Using Excel VBA to run SQL query
  22. How do I implement pagination in SQL for MS Access?
  23. SQL to add column with default value – Access 2003
  24. Achieving ROW_NUMBER / PARTITION BY in MS Access
  25. How can I implement SQL INTERSECT and MINUS operations in MS Access
  26. Convert String to Date in MS Access Query
  27. MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
  28. How do I perform update query with subquery in Access?
  29. SQL Update woes in MS Access – Operation must use an updateable query
  30. How do I create a decimal field in Access with Alter Table?

Leave a Comment