'调用函数
if tbExitDb("GZ_1","gz.mdb") then MsgBox "GZ_1表存在数据库gz.mdb中!", vbOKOnly + 64, "消息框"
'判断数据库中是否存在某个表函数
Public Function tbExitDb(tbName As String, dbName As String) As Boolean
Dim Idx As Long
If Len(Dir(dbName)) Then
Set db = OpenDatabase(dbName)
tbExit = False
For Idx = 0 To db.TableDefs.Count - 1
If tbName = CStr(db.TableDefs(Idx).Name) Then
tbExit = True
Exit For
End If
Next Idx
db.Close
End If
End Function