刷新联接表的函数

来源: 点击数:6957 　 | 收藏 | 复制

时　间:2008-05-31 08:29:40
作　者:OFFICE中国 ID：16 城市：江阴
摘　要:刷新联接表的函数
正　文:

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

Access软件网QQ交流群 (群号:54525238) 　　　　　　Access源码网店

【打印此文】【关闭窗口】