This is a bad way to do it, but might work if you find no other answer. Or else you should convert to SQL Server... :)<BR><BR>on error resume next<BR>connection.execute("SELECT 1 FROM " & TableName)<BR>If err.number <> 0 Then<BR> response.write("Table: Not found")<BR>Else<BR> Response.Write("Table: OK")<BR>End If<BR><BR><BR>I don't think this is a very good way to do it though...<BR><BR><BR>- jørn
If you are using DAO then use Database.Tabledefs to see if any table exists. <BR>Set mydb = OpenDatabase(......)<BR>then checkout for with mydb.tabledefs<BR><BR>If you are using ADO then use Openschema method and then check for Recordset("Table_Name") field i.e. Rs(3). If it returns anything then the table exists else no table ........<BR><BR>I hope with this as hint and some reference to the MSDN, you should be able to do. Best of Luck.