I am working on a project for the National Park Service. The goal of the project is to connect a Microsoft Access Database to a File Geodatabase, where any information put into the .accdb tables will automatically be put into the FGDB tables. The reason for this is that it will enable other employees in our park without GIS experience to easily put in data from cave surveys into the simplified UI we made for the accdb. We want that data to then be transferred to the FGDB as seamlessly as possible; the end goal is to have something that gets it done with one process and no other hassles involved.
So far I have connected the access database to ArcCatalog via an OLE Database link, which works without issue. However, I am having trouble figuring out how to set up a way in which data from the accdb will be automatically sent to the FGDB, without having duplicates that we would have to manually delete. The only way I could think of was to set up a model like in image I included below; it only includes the model for just one of the table datasets needed. It almost works, but it keeps deleting the wrong set of duplicates. It deletes the new set (the most current data), not the old set. Essentially, I am just trying to have the model overwrite the older cave survey data and replace it with the newer data. If I could find a way to have the model delete the older duplicate set, it would do exactly what I want it to.
Can anyone give me input on my method or recommend another?
I have limited python experience.