技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 3506
|
2#
發(fā)表于 2009-4-21 06:59:59
|
只看該作者
如何在局域網(wǎng)上實(shí)現(xiàn)自動升級?
(A)
1.建一個(gè)啟動程序log_on.mdb
2.判斷本地主程序與服務(wù)器端主程序的版本是否一致
采用GetVersion函數(shù)來獲得版本號
Public Function GetVersion(FileName As String, strPWS As String) As String
Dim rst As ADODB.Recordset
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & FileName & ";jet oledb:database password='" & strPWS & "'"
strSQL = "select * from tblversion"
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
rst.Open strSQL, strConn
rst.MoveFirst
GetVersion = rst!Version
rst.Close
Set rst = Nothing
End Function
3.將服務(wù)器端的主程序替換本地主程序
Dim SourceFile As String
Dim DestinationFile As String
Dim localVision As String
Dim serverVision As String
' 指定服務(wù)器上的文件名。
' SourceFile = "\\172.16.172.6\server\main.mdb"
SourceFile = CurrentProject.Path + "\server\main.mdb"
' 指定本地文件名。
DestinationFile = CurrentProject.Path + "\main.mdb"
If Dir(SourceFile) = "" Then
MsgBox SourceFile & vbCrLf & "網(wǎng)路不通或文件不存在!", vbCritical, "提示"
Exit Sub
End If
'獲得本地主程序的版本號
localVision = GetVersion(DestinationFile, "")
'獲得服務(wù)器端升級文件的版本號
serverVision = GetVersion(SourceFile, "")
If localVision = serverVision Then
'運(yùn)行主程序
OpenDB
Else
MsgBox "版本不同,現(xiàn)在開始升級!", vbInformation, "提示"
FileCopy SourceFile, DestinationFile
MsgBox "版本升級結(jié)束!", vbInformation, "提示"
'運(yùn)行主程序
OpenDB
End If |
|