Need to display msg if table exists in Access2003 dB
Posted on 2012-04-09
I have an access 2003 dB with code that imports data into several tables and executes Queries and stuff. SetWarnings is false and I need to keep it that way.
Once in a while, there will be a problem whereby some records fail to be imported into a particular table and I need to know when this has happened - but not until after all the VBA code has run since there will be occasions when these missing records are acceptable.
I'm looking for some VBA code I can place at the end of the Sub that will check for the presence of any table in the dB that has a suffix of "_ImportErrors" and send me a msg if one or more tables have this suffix.