Solved

Migrate Access 2007 database to FEBE

Posted on 2012-04-02
3
329 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Converting Excel to OFX 2 128
Cannot get OneDrive working on Wndows 10 2 63
Flashing Formula Excel - Caused by VBA? 7 76
SharePoint 2013 Site Replacement 6 50
MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

679 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