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! 🙂