I have a routine that creates a temporary table, and at the end deletes it. However, I would like to check at the beginning of the routine if the table is still there just in case it didn't get deleted the last time. How do I do this?
Unfortunately there is not function for that in Access97 (may be in A2k).
You can is to read the TableDefs collection of the Database object to check the
name of your table, or to test a property like recordcount and
intercept the error if the table does not exist.