技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 1810
|
6#
發(fā)表于 2017-2-28 15:55:57
|
只看該作者
Public Function gf_LinkSqlServer() As Boolean
On Error GoTo Err_LinkSqlServer
Dim strConn As String, dbCurr As DAO.Database
Dim tdf As Object
Dim dbs As Object
strConn = "ODBC;DRIVER=SQL Server;SERVER=IP,端口;DATABASE=sql數(shù)據(jù)庫(kù)名;UID=saWD=密碼"
Set dbCurr = DBEngine.Workspaces(0).OpenDatabase("OfficeCn", False, False, strConn)
Set dbs = CurrentDb
For Each tdf In dbs.TableDefs
If tdf.Connect <> "" Then
tdf.Connect = strConn
tdf.RefreshLink
End If
Next
dbCurr.Close
Set dbCurr = Nothing
MsgBox "連接成功", vbInformation, "連接SQL Server"
gf_LinkSqlServer = True
Exit Function
Err_LinkSqlServer:
Err.Clear
MsgBox "連接出錯(cuò)!", vbCritical, "連接SQL Server"
gf_LinkSqlServer = False
DoCmd.Quit
End Function
|
|