创建ODBC链接表连SQL源码示例

时　间:2013-04-20 12:52:02
作　者:杜超-2号   ID：16058  城市：江阴
摘　要:链接SQL上的tblcode_kh表示例
正　文:

点击下载附件

Private Sub 创建_Click()
    Dim cnn As String
    Dim dbs As Object    'Database
    Dim tdf As Object    'DAO.TableDef
    Set dbs = CurrentDb
    '下面是ODBC连接SQL字符串
    strConnect = "ODBC;DRIVER=SQL Server" & _
                 ";SERVER=192.168.6.128" & _
                 ";DATABASE=BSX" & _
                 ";UID=sa" & _
                 ";PWD=123"

    Set tdf = dbs.CreateTableDef("tblcode_kh_b")  '创建链接表,命名为tblcode_kh_b
    tdf.Connect = strConnect
    tdf.SourceTableName = "tblcode_kh"    'SQL源表
    dbs.TableDefs.Append tdf
    Set dbs = Nothing
    Set tdf = Nothing
    Application.RefreshDatabaseWindow  '刷新
    MsgBox "创建成功，请查看表"
End Sub

Private Sub 删除_Click()
    DoCmd.DeleteObject acTable, "tblcode_kh_b"
    Application.RefreshDatabaseWindow  '刷新
    MsgBox "删除成功"

End Sub