from_load
set db=opendatabase(数据库)
for i=0 to db.TableDefs.count-1
if lcase(db.TableDefs(i).name)=lcase(想要知道存在的表名) then
msgbox "该表存在"
else
msgbox "该表不存在"
exit sub
end if
next i
ADO帮助里的。^_^修改了一下
Public Function OpenSchemaX() AS Boolean
Dim cnn1 As ADODB.Connection
Dim rstSchema As ADODB.Recordset
Dim strCnn As String
Set cnn1 = New ADODB.Connection
strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\gaoqi.mdb;Persist Security Info=False;Jet OLEDB:Database Password=gaoqi"
cnn1.Open strCnn
Set rstSchema = cnn1.OpenSchema(adSchemaTables)
Do Until rstSchema.EOF
If Not Left(rstSchema!table_name, 4) = "MSys" Then
Debug.Print "Table name: " & _
rstSchema!table_name & vbCr & _
"Table type: " & rstSchema!TABLE_TYPE
if rstschema!table_name="你的表名" then
OpenSchemaX=true
exit function
end if
End If
rstSchema.MoveNext