Solved

Migrate Access 2007 database to FEBE

Posted on 2012-04-02
3
335 Views
Last Modified: 2012-04-06
I administer an Access 2007 dastabase.  I need to migrate 40 stand alone versions of the database to a single FEBE configuration on a secure server.  

Q: Is there anything I should know before deploying this?  Simulations have gone smoothly...which is what worries me.

Q: Should I consider migrating to Access 2010 while I am making changes?  My company is on Office 2010 so this would keep OAS on the same page.
0
Comment
Question by:CLTMARKMAN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 81

Expert Comment

by:David Johnson, CD, MVP
ID: 37799751
I need to migrate 40 stand alone versions of the database to a single FEBE configuration on a secure server.  

Why would you have 40 stand alone versions of a database and not use a central file/database? How do you plan on syncing these databases?  

What is FEBE? and what is OAS?
0
 

Author Comment

by:CLTMARKMAN
ID: 37800826
The original vision was a stand alone database, used to record equipment maintenance in 40 different but similar locations throughout the company.  As the vision has evolved we realized we should have everyone working in the same database instead of separate.  (Sounds pretty short sited, but the fundamental intent of the database has changed.)

FEBE is Front End Back End-meaning splitting the database and have all locations linked to the same tables on a secure network server.  OAS is Office Automation System-an acronym I picked from the in-house IT group.

What do you mean Syncing?  Once their data is transferred to the FEBE configuration, what syncing is required?
0
 
LVL 81

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 37801511
As you configure each machine, you could export each separate database to a csv and then import it into the master database, the problem being that the indexes will try and overwrite each other.. what you could do is prefix each table with the department name/number or machine-name of the originating database

I'd try 2 machines in a test environment first, just copy off their mdb's and this way you can check for problems/errors, don't forget to do a complete test.  If this works out then you can roll it out.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question