Solved VBA copy data from one database to another (1 Viewer)

[Rania01]

I have 2 different databases:


1 Master Data
2 Data Backup


Please help to create a VBA command button to copy the result of the search in database called "Master Data" to Table called "BackupData" in another database called "Data Backup".


My data is ON

C:\Kirana\Data access

Thank you in advanced

 

[Ranman256]

dont really need vba. Link in the target tables to copy to, as external linked tables.
make append queries to add the local data to their target tables,
put all these queries in a macro.
put the macro in the button click event.

 

[Rania01]

To deleted old record after backup i use VBA

Private Sub DeleteOlddata()

Dim strPasswd
    Dim stDocName As String
    Dim stLinkCriteria As String

    On Error GoTo Err_Command6_Click_Error
    strPasswd = InputBox("Enter Password", "Restricted Form")

    If strPasswd = "" Or strPasswd = Empty Then
        MsgBox "No Input Provided", vbInformation, "Required Data"
        Exit Sub
    End If

    If strPasswd = "12345" Then
    DoCmd.RunCommand acCmdSelectAllRecords
    DoCmd.RunCommand acCmdDelete
    Else
        MsgBox "Sorry, you do not have access to this form", vbOKOnly, _
            "Important Information"
        Exit Sub
    End If
Exit_ErrorHandler:
  Exit Sub
Err_Command6_Click_Error:
  If Err.Number = 2501 Then
    MsgBox "Delete action cancelled"
    Resume Exit_ErrorHandler
  Else
    MsgBox "Error " & Err.Number & " (" & Err.Description & _
        ") in procedure Command6_Click of VBA Document Form_T2 at Line " & Erl
    Resume Exit_ErrorHandler
  End If



End Sub

The problem is How to copy the result of the search in database called "Master Data" to Table called "BackupData" in another database called "Data Backup".

 

[XPS35]

Double crossposted https://www.accessforums.net/showthread.php?t=86715 and https://www.helpmij.nl/forum/showth...r-gegevens-van-de-ene-database-naar-de-andere