Which is better? checking in VBA or SQL

[allstar45]

I currently have a VBA statment that runs SQL to append to a table.

I want to first check if there is already a record with the same name in the table to avoid duplicate entrys.

Is it best to check before the query is run in the VBA, or in the SQL statment it's self to avoid this problem better?

I'm not sure how I even would check the table with SQL.




Thanks in advance!

[pbaldy]

I would tend to check in VBA before running the SQL. You can use DCount or a recordset.