Office中国论坛/Access中国论坛 › Access中国门户旧版 ›Access› 表 › 查看内容

刷新联接表的函数

1970-1-1 08:00| 发布者: 想不通| 查看: 3077| 评论: 0

Public Sub Tablsx(Strtext As String) '刷新联连表，参数为联接表的址及文件名，USYS_Tabl是存放联接表名的表。
Dim hdk As String
Dim cat As ADOX.Catalog
Dim tdf As ADOX.Table

hdk = Strtext
Set cat = New ADOX.Catalog
Set cat.ActiveConnection = CurrentProject.Connection
Dim db As ADODB.Connection

Dim rs As Recordset
Dim BIAO As String
Set db = New ADODB.Connection
Set rs = New ADODB.Recordset
rs.ActiveConnection = CurrentProject.Connection
rs.Open "USYS_Tabl", , adOpenKeyset, adLockOptimistic, adCmdTable
rs.MoveFirst
Do Until rs.EOF
BIAO = rs!id
Set tdf = cat.Tables(BIAO)
tdf.Properties("jet oledb:link datasource") = hdk
rs.MoveNext
Loop
rs.Close
DoCmd.Close
End Sub

**************************
全部表都是联接表时用
Public Sub Ffff(strtext As String)

Dim cat As ADOX.Catalog
Dim tdf As ADOX.Table

Set cat = New ADOX.Catalog
Set cat.ActiveConnection = CurrentProject.Connection
For I = 6 To cat.Tables.count
Set tdf = cat.Tables(I)
tdf.Properties("jet oledb:link datasource") = strtext

Next I

End Sub

收藏分享邀请

帐号		自动登录	找回密码
密码			注册

刷新联接表的函数

最新评论

相关分类