刷新联接表的函数_access数据表-access表-access表设计

刷新联接表的函数

时间：2006-11-24 23:58 来源：ACCESS设计在线作者：想不通阅读：次

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

(责任编辑：admin)

顶一下

(0)

踩一下

(0)

上一篇：外部驱动程序（8961）中的意外错误
下一篇：如何设置表的Caption和Description属性，即“标题”和“说明”属