Solved

Migrate Access 2007 database to FEBE

Posted on 2012-04-02
3
324 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
  • 2
3 Comments
 
LVL 80

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 80

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to refer to cell 8 86
Office Web Apps/ SharePoint 2013 1 97
Where is user Lync data stored 4 103
SharePoint 2013 URL Duplication Issue 5 25
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

828 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