1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
| Public Sub Com5_Click()
Dim leChemSauve As String, FichSauve As String, FichFullName As String, rep
FichSauve = "SaveParams.accdr"
leChemSauve = Nz(DLookup("Chemin", "CHEMINS", "Fonction='" & "Sauvegarde" & "'"), "")
FichFullName = leChemSauve & "\" & FichSauve
rep = Dir(FichFullName)
If rep <> "" Then
rep = MsgBox("Une sauvegarde précédente a été trouvée." & CRLF & CRLF & _
"Voulez-vous la remplacer ?", vbQuestion + vbOKCancel, "R² Holistic")
If rep = 2 Then
Exit Sub
Else
End If
Kill (FichFullName)
End If
'Création de la nouvelle base
Dim wrkDefault As Workspace
Dim dbsNew As Database
Dim MyTableDef As TableDef
Set wrkDefault = DBEngine.Workspaces(0)
Set dbsNew = wrkDefault.CreateDatabase(FichFullName, dbLangGeneral)
DoEvents
Set dbsNew = Nothing
'Approbation emplacement
Call EmplacementSauvegardeApprouve
'Exportation des tables de paramètres
DoCmd.TransferDatabase acExport, "Microsoft Access", FichFullName, acTable, "Chemins", "Chemins"
DoCmd.TransferDatabase acExport, "Microsoft Access", FichFullName, acTable, "MSysBook", "MsysBook"
DoCmd.TransferDatabase acExport, "Microsoft Access", FichFullName, acTable, "MSysTMP", "MsysTMP"
DoEvents
'Name FichFullName As leChemSauve & "\SaveParams.accdr"
Com6.Enabled = -1
rep = MsgBox("Sauvegarde paramètres effectuée", vbInformation + vbOKOnly, "R² Holistic")
End Sub |
Partager