Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Migrate Access 2007 database to FEBE

Posted on 2012-04-02
3
Medium Priority
?
344 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 83

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 83

Accepted Solution

by:
David Johnson, CD, MVP earned 1000 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

721 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