怎么判斷一個access數據庫中某個表是否存在的方法?
select name from MSysObjects where type=1 and flags=0sql="select * from 表 order by name asc" Set myrs1 = mydata.OpenRecordset(sql)If myrs1.EOF = True Thenmsgbox "有這個表"elsemsgbox "沒這個表"end if
下一篇歷史上有哪些奇案
怎么判斷一個access數據庫中某個表是否存在的方法?
select name from MSysObjects where type=1 and flags=0sql="select * from 表 order by name asc" Set myrs1 = mydata.OpenRecordset(sql)If myrs1.EOF = True Thenmsgbox "有這個表"elsemsgbox "沒這個表"end if