Struggling with MS Access

While it isn’t really relevant to the wp-swimteam plugin, it is related to swim team.  Our team is using WinSwim for meet management which relies on Crystal Reports for generating reports.  I have been customizing reports for our team and am working on one which requires me to really poke into Access.

I have done quite a bit of work with MySQL so it is frustrating to encounter SQL constructs which Access doen’t support.  Right now I am struggling with how to determine if a table in Access already exists and if it does, I want to drop it.  What a PITA.  Access doesn’t support the DROP TABLE IF EXISTS construct which MySQL (and others) support.

If you know how to do this, please tell me how in the comments!  🙂