How do I determine if a table exists in an Access database?

We can take one of our existing schema extractors from other articles, and modify it slightly: 
 

<%      tableToFind = "foo"      dbname = "/file.mdb"         ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;data source="           ConnStr = ConnStr & server.mappath(dbname)        set adoxConn = CreateObject("ADOX.Catalog")       set adodbConn = CreateObject("ADODB.Connection")       adodbConn.open ConnStr       adoxConn.activeConnection = adodbConn       found = false      for each table in adoxConn.tables          if lcase(table.name) = lcase(tableToFind) then              found = true              exit for          end if      next      adodbConn.close: set adodbConn = nothing       set adoxConn = nothing           if found then          response.write("Table exists.")      else          response.write("Table does not exist.")      end if  %>

 
You could also query the MSysObjects table: 
 

<%      tableToFind = "foo"      dbname = "/file.mdb"         ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;data source="           ConnStr = ConnStr & server.mappath(dbname)        set adodbConn = CreateObject("ADODB.Connection")       adodbConn.open ConnStr         sql = "SELECT COUNT(*) FROM MSYSObjects WHERE Type = 1" & _          " AND [Name]='" &     tableToFind & "'"        set rs = adodbConn.Execute(sql)      found = rs(0)          if found then          response.write("Table exists.")      else          response.write("Table does not exist.")      end if  %>

 
For information on determining existence of tables in SQL Server, see Article #2458.