使用错误处理方法判断,
Private Function IfTableExists(Byval TableName As String) As Boolen
On Error Goto Err1
dim Conn as New Adodb.Connection
sql="Select * From " & TableName
Conn.ConnectionStrings="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\XXXX.mdb"
Conn.Open
Conn.Execute Sql,,adCmdText
Exit Funtion
Err1:
IF Err.Number<>0 Then
Debug.Print Err.Descrption
End IF