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.
Printable View
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.
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
In oracle you could try selecting for the table name against the TAB table.
Chip