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

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




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