Is table exist

[farah]

Hello everyone,

How can I chech if the table is exist in a database? Just in case if someone delete my table inside a database.

[Serge]

Let's say you are looking for a table named MyTable.

Then you would use something like:


Dim db As Database
Dim tb As TableDef

Set db = Workspaces(0).OpenDatabase("C:\MyDB.mdb")

For each tb In db.TableDefs
If tb.Name = "MyTable" Then
'You found your table
Exit For
End If
Next



Best regards,

------------------

Serge

[email protected]
[email protected]
If you have any questions about AOL programming, e-mail me

[ccox]

In oracle you could try selecting for the table name against the TAB table.
Chip