HotRodSue
asked on
How do I "merge" Access 2007 database?
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.
ShenandoahDairyFuel-2011-10-01-B.accdb
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.
ShenandoahDairyFuel-2011-10-01-B.accdb
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your input, Jim. I appreciate all help and info shared here. This is my first and only complete database. There is so much to learn. I'll keep plugging away at this one and will let you all know have the changes/updates go.
ASKER
Alright, I'm back at this today. Since the customer made no changes to the FE, I replaced it. Then I imported my new table into the BE, and created the relationshiips for the new table.
Now it seems the newly replaced FE is not connected to the BE. When I open the FE, it "sees" my orginal empty tables, rather than the customers existing tables with data.
I've created a Trusted Location. Then I tried the "Re-Link Tables" manager, and thought I'd be able to Browse to the location of the tables I need to be linked to, however, I could not.
How can I get the FE and BE working together?
Now it seems the newly replaced FE is not connected to the BE. When I open the FE, it "sees" my orginal empty tables, rather than the customers existing tables with data.
I've created a Trusted Location. Then I tried the "Re-Link Tables" manager, and thought I'd be able to Browse to the location of the tables I need to be linked to, however, I could not.
How can I get the FE and BE working together?
<<I've created a Trusted Location. Then I tried the "Re-Link Tables" manager, and thought I'd be able to Browse to the location of the tables I need to be linked to, however, I could not.>>
That's the ticket (linked table manager). What was the problem browsing to the BE?
Jim.
That's the ticket (linked table manager). What was the problem browsing to the BE?
Jim.
ASKER
Jim, I feel quite silly. I needed to check the box "Always Prompt to Browse to Location". Then I was able to browse to and link the tables. It looks like I've got it. Thanks for the help.
<<Jim, I feel quite silly. >>
Easy one to solve ;)
Glad to hear your on your way...
Jim.
ASKER
As always, the experts here help me with excellence and in a timely manner. Every time I have used Experts Exchange, you've provided a solution. I'm never stuck for long, when I come here. Many thanks for the kind help.
Sue
Sue
ASKER
It makes sense that the changes must not affect the original Access objects. The DB was set up to track 3 types of fuel; gasoline, off road diesel, and on road diesel. Now, they added another fuel tank. So, I added another table to track the additional tank. I don’t believe the changes will affect the original Access objects. If you think there is something specifically I should look for, let me know.
Your instructions are clear and easy, thank you for keeping it simple. Also, I appreciate the information on how to accomplish the process via remote connection. That’s great info to have. E-mail, is another great option. It’s nice to come in here and get such expert help.
Within the next couple of days I’ll have the opportunity to give this a try. Is it alright to award points now and post a follow up question, should I have any question while I’m in the process?