Jun 13th, 1999, 12:13 PM
How can I chech if the table is exist in a database? Just in case if someone delete my table inside a database.
Jun 13th, 1999, 03:02 PM
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
If you have any questions about AOL programming, e-mail me
Jun 15th, 1999, 08:37 PM
In oracle you could try selecting for the table name against the TAB table.