MS Access (ADO): AddNew/Delete/Update vs. SQL statements
Posted on 2004-09-17
I have an application that uses a MS Access database via Jet 4.0.
1) Which is better to implement, using the AddNew/Delete/Update way or using SQL statements, e.g. INSERT/DELETE/UPDATE to add, delete and update records in the database?
Please explain why and to give code snippets re:how to use the better implementation.
2) What type of error handling should be implemented when the database functions are unsuccessful?
If possible, please give code snippets.