Dim dbSource As Database
Dim wspSource As Workspace ''工作区
Dim intTableLoop As Integer
Dim intTablesCount As Integer ''表数计数器
Set wspSource = DBEngine.Workspaces(0)
Set dbSource = wspSource.OpenDataBase(FileName) ''打开数据库
intTablesCount = dbSource.TableDefs.Count ''获得表数目
intTablesCount = dbSource.TableDefs.Count ''获得表数目
''获得表名及其中文标题
rintTablesCount = 0
For intTableLoop = 0 To intTablesCount - 1
'...
Next intTableLoop
dbSource.Close ''关闭数据库
Set dbSource = Nothing
wspSource.Close ''关闭工作区
Set wspSource = Nothing
Dim wspSource As Workspace ''工作区
Dim intTableLoop As Integer
Dim intTablesCount As Integer ''表数计数器
Set wspSource = DBEngine.Workspaces(0)
Set dbSource = wspSource.OpenDataBase(FileName) ''打开数据库
intTablesCount = dbSource.TableDefs.Count ''获得表数目
intTablesCount = dbSource.TableDefs.Count ''获得表数目
''获得表名及其中文标题
rintTablesCount = 0
For intTableLoop = 0 To intTablesCount - 1
'...
Next intTableLoop
dbSource.Close ''关闭数据库
Set dbSource = Nothing
wspSource.Close ''关闭工作区
Set wspSource = Nothing
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货