Hello,
I have to table in my main db and what I would like to do is that once I click on a button my macro runs and then it takes the 2 tables and copies it into my backUp db.....
But I also want to make sure that everytime I click on the macro well the old records in the table to get replaced by the new ones..therefore just added...
Can someone tell me how to do this....Please
Ok here is the code I have for my cmd button
DoCmd.TransferDatabase acImport, "Microsoft Access", _
"L:\HoraSec\Data\Dispatch.mdb", acTable, "AgentTrackingModification_tb", _
"AgentTrackingModification_tb"
But what this does is tha it creates the table in the same ds I want it to go into the DB named BackUp
I have to table in my main db and what I would like to do is that once I click on a button my macro runs and then it takes the 2 tables and copies it into my backUp db.....
But I also want to make sure that everytime I click on the macro well the old records in the table to get replaced by the new ones..therefore just added...
Can someone tell me how to do this....Please
Ok here is the code I have for my cmd button
DoCmd.TransferDatabase acImport, "Microsoft Access", _
"L:\HoraSec\Data\Dispatch.mdb", acTable, "AgentTrackingModification_tb", _
"AgentTrackingModification_tb"
But what this does is tha it creates the table in the same ds I want it to go into the DB named BackUp
Last edited:
