Results 1 to 7 of 7
  1. #1
    sri123 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    12

    MS Access 2007- Migration : Need suggestions

    Hello Everyone,


    We have an Access Application built on Access 2007.
    This is built in Split Data Architecture, The backend sits on the shared drive and the front-end is on Users Machine.

    As a matter of security our organization has decided to move the back-end data to SQL SERVER or ORACLE.

    Also the new Office 365 is going to come around in few months.

    Plan is to keep the front-end still in Access and move the back-end to some other platform.

    Questions:
    Moving Back-end to Oracle is technically good option? as the enterprise standard is Oracle platform in our organization.

    Once the back-end is moved, How does Office 365 will have impact on our application (the front-end)

    What are the steps involved to upgrade to new office 365,
    for example, the Application is already on users machine which Access 2007, in a week the organization is uninstalling the Office 2007 and installing Office 365.
    When the user opens the App on Office 365, will it work?

    As a developer do we need to do any pre-work on this?

    Today, the application is working perfectly with around 100 users.

    Please let me know your experiences and valuable thoughts, as this is going to be a challenging task for me.

    Any help or information is highly appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I have done this and there was no problem. We moved to SQL server...just name all your tables EXACTLY the same and it works fine.
    Just relink to SQL tables and boom...youre up.

    1 NOTE:
    if the table was created new and the field was made YES/NO to start, it worked fine, BUT, we had some glitches with a YES/NO field....if it was INTEGER , then later modified to YES/NO in SQLSvr ,we had problems.
    So create new yes/no fields.

  3. #3
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    I have done this. Most of the database processes worked exactly like they did previously, there were just difference references to tables in the linked table manager in access.

    Access has some tools to help migrate data from access to SQL.
    As said above:
    I have heard of issues where boolean fields use to not convert property when -1, 1 and 0 were used to store values.

  4. #4
    sri123 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    12
    Thank you for your reply.
    I too did two migrations like this before to SQL SERVER, I know its pretty easy.

    How about doing to Oracle.
    Also how does Access behave when you migrate to Office 365

  5. #5
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    I have not noticed any difference in how access interacts with SQL/Oracle backends vs access backends besides how records are deleted. In the most recent versions of access, I believe there is an option for the object to manage this interaction of deleting records.

    I tried to google this to find a reference for you, but murphy said no and I couldn't find it.

  6. #6
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397

  7. #7
    sri123 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    12
    I didnt knew both the threads belong to same forum, aplogize for the redundancy.
    I have posted my thoughts on the other site.

    And thanks everyone for your valuable inputs. Appreciate your time on this.

    http://www.access-programmers.co.uk/...=1#post1420842

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 04-07-2014, 10:01 AM
  2. Replies: 2
    Last Post: 06-19-2013, 09:08 AM
  3. Access To SQL Server Migration
    By Rxp in forum Access
    Replies: 6
    Last Post: 05-07-2012, 05:50 PM
  4. Migration from Access 2003 database to Access 2007 database.
    By cyclus2 in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 11:43 AM
  5. Replies: 3
    Last Post: 06-24-2010, 07:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums