Dim reaTemp As SqlDataReader
Dim intQuestion As Integer
Me.lblMessages.Text = "Begin Check for updates"
datTime = datTimeLaps
reaTemp = Docmd.FillDataReader("SELECT versionnumber FROM dbo.[tbl_versionnumber]", Docmd.Databases.General)
reaTemp.Read()
strTemp = reaTemp.GetValue(0)
reaTemp.Close()
If Me.lblversion.Text.Trim <> strTemp.Trim And strTemp.Length > 0 Then
Select Case Language.strlanguage
Case "nl"
intQuestion = MessageBox.Show("Er is een nieuwere versie gevonden van de Tex databases, wilt u die nu installeren? alle openstaande databases zullen worden gesloten, vergeet niet te saven.", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
Case "fr"
intQuestion = MessageBox.Show("Une version plus récente est disponible, souhaitez-vous l'installer maintenant? Toutes les bases de données ouvertes seront fermées automatiquement, veuillez sauver vos données avant de lancer l'installation!", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
Case "en"
intQuestion = MessageBox.Show("There is a newer version available, do you want to install it now? All open databases will be closed automatically. Don't forget to save!", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
End Select
If intQuestion = 6 Then
Dim proTemp As New System.Diagnostics.Process
proTemp.StartInfo.FileName = "s:\setup.exe"
proTemp.Start()
proTemp.WaitForExit(100000)
proTemp.StartInfo.FileName = Application.StartupPath & "\tex databases.exe"
proTemp.Start()
Me.Close()
End If
End If
Me.lblMessages.Text = "End Check for Updates"
Me.Local_Update_Thread = Nothing