locked
convert ms access 2007 to sql server 2012 RRS feed

  • Question

  • Hello, I have an ms access 2007 database that i can not open to another pc due to multiple errors. I want to convert it to sql server 2012. How i can convert it?! Am i about to lose forms, print layouts etc?please advise about the steps 
    Tuesday, June 14, 2016 10:39 AM

Answers

All replies

  • Start reading this article

    http://sqlmag.com/database-administration/15-steps-convert-access-data-sql-server

    and this one

    https://msdn.microsoft.com/en-us/library/hh313041(v=sql.110).aspx


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Tuesday, June 14, 2016 10:42 AM
    Answerer
  • Am i about to lose forms, print layouts etc?

    In SQL Server stack with have no forms, but you can connect you MS Access application to SQL Server, so you can use your current forms with SQL Server data.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, June 14, 2016 1:24 PM
  • Hello,

    Please read the following article:

    https://blog.tallan.com/2012/01/16/a-look-at-how-to-migrate-an-access-database-to-sql-server-part-1-of-2/  
       

    Hope this helps.

    Regards,



    Alberto Morillo
    SQLCoffee.com

    Tuesday, June 14, 2016 2:41 PM
  • The errors are probably related to the fact that Access 2007 is not compatible with the operating system of the PC you are attempting to copy it to.

    If this is a shared Application then you need (a) a central data repository (Access or SQL Server will suffice); all PC's to have the same IDENTICAL operating system and patch level and (c) carry out an upgrade process to update the Access Forms, code etc to a more recent version of MS Access.

    The identical OS part is crucial as you could be using DLL's etc; and Access does behave differently according to the OS.

    Having worked with Access in the past this is the system I adopted: -

    Data was in SQL Server

    Master Access MDB File; with the data linked via the Linked Table Manager

    All Access objects created in the MDB file

    Password protect and MDB file

    Deploy the MDB file as an MDE, removing the password but locking down the main window so the only way it could be used was through the forms.


    Please click "Mark As Answer" if my post helped. Tony C.

    Tuesday, June 14, 2016 3:09 PM