Office中國(guó)論壇/Access中國(guó)論壇 › Access中國(guó)門戶舊版 ›Access› 表 › 查看內(nèi)容

刷新聯(lián)接表的函數(shù)

1970-1-1 08:00| 發(fā)布者: 想不通| 查看: 3158| 評(píng)論: 0

Public Sub Tablsx(Strtext As String) '刷新聯(lián)連表，參數(shù)為聯(lián)接表的址及文件名，USYS_Tabl是存放聯(lián)接表名的表。
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

**************************
全部表都是聯(lián)接表時(shí)用
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

收藏分享邀請(qǐng)

帳號(hào)		自動(dòng)登錄	找回密碼
密碼			注冊(cè)

刷新聯(lián)接表的函數(shù)

最新評(píng)論

相關(guān)分類