A few years ago I created a DB using Access 2007, and OS Win XP Pro. It’s a simple DB to track fuel usage. Before distributing to the customer, the DB was backed up and then split. Access is not something I work in on a regular basis.
Now, the customer needs another form added to the DB. I’ve gone back to the original DB created before the split, and re-familiarized myself with it. At this time, I’ve completed the updates which include a new table, new queries, new forms, and new reports. All of the original tables, queries, forms, and reports are unchanged and need to remain as is.
My next step is to get a back up of the data from the customer’s current DB. Then, I need direction on how to “merge” the original database with the updated one, both being Access 2007. Would I “export” or “backup” the data from the customer’s current DB? Then, “import” the data into my updated DB? Am I on the right track at all? Thanks in advance for your help.