• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

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
0
HotRodSue
Asked:
HotRodSue
  • 5
  • 3
2 Solutions
 
pdebaetsCommented:
It is key that the changes you made do not affect the original Access objects. Perhaps you can explain in another post how you managed to do this. :-)

Anyway, the easiest way to do this is to backup the customer's front-end and data back-end, then open the customer's data back-end and import your new table. Then open the customer's front-end and import your new queries, forms, reports. Test that your changes are working OK for your customer, then you should be good to go.

If you cannot visit your customer to do this, you can do it via remote connection. I use LogMeIn.com or GoToAssist for this purpose. You may be able to sign up with GoToAssist for a free 30-day trial.

You can do this via e-mail as well. When the customer sends you the data back-end via attachment, make sure they do not make any data changes until you've returned the file and they've replaced the old data back-end with your updated one.

 
0
 
HotRodSueAuthor Commented:
Thank you for all the detailed information.  It seemed to me it would be relatively easy.  However, my concern was maintaining their data and having a working, updated DB.

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?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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. >>

  As an aside, this indicates that your DB design is incorrect.  You should not have to change the design simply because they need to add another tank.

<<Anyway, the easiest way to do this is to backup the customer's front-end and data back-end, then open the customer's data back-end and import your new table. Then open the customer's front-end and import your new queries, forms, reports. Test that your changes are working OK for your customer, then you should be good to go. >>

  If the customer has not made changes to the front end, then simply replace it.  Less chance of messing up.

  If they have modifed your FE, then really you should get a copy of it, import your changes, test, and then replace the FE that they have with your tested version (and make sure they don't make any changes between the time you copy theirs and return a tested version).

Jim.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
HotRodSueAuthor Commented:
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.
0
 
HotRodSueAuthor Commented:
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?    
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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.
0
 
HotRodSueAuthor Commented:
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.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

<<Jim, I feel quite silly. >>

 Easy one to solve ;)

 Glad to hear your on your way...

Jim.
0
 
HotRodSueAuthor Commented:
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
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now