Results 1 to 3 of 3
  1. #1
    spdaccess is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Posts
    2

    Create Access 2016 desktop database from existing SQL Server 2008 R2 database

    Hi All,



    New to forum and Access so please be gentle :-)

    I have a SQL Server database that I would like to create a copy of in a Access 2016. Is that possible via export/import process as opposed to manually creating all the tables in Access.

    In case anyone is interested I wish to do this for various reason.

    1) I would like to test UI development on a local database where I won't have access to the SQL Server,

    2) The SQL Server database is a new empty database that will be distributed to various clients. The 'setup' phase of working with the database includes importing a lot of data which I am currently doing with SSIS and Excel spreadsheet. It is a nightmare for my clients so I wanted to create a Access UI/Database for them to work with in setting up there data and then provide SSIS packages takes that data from the Normalized Access database and populates the SQL Server database

    Hope that makes sense

    Thanks
    Steve

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Yes , just create MAKE table queries.
    select SQL tbl, make local access tbl.

  3. #3
    spdaccess is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Posts
    2
    Hi ranman256,

    Thanks for the quick reply. That would definitely make it easier but is there anyway to get the relationships and views or will I have to do that manually?

    Thanks
    Steve

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

Similar Threads

  1. Replies: 14
    Last Post: 12-30-2015, 09:42 AM
  2. Replies: 1
    Last Post: 03-21-2015, 11:55 AM
  3. Moving an existing Access Database backend into a SQL Server?
    By IncidentalProgrammer in forum SQL Server
    Replies: 9
    Last Post: 09-16-2014, 08:13 AM
  4. Replies: 4
    Last Post: 05-18-2012, 12:42 PM
  5. Replies: 2
    Last Post: 03-30-2012, 02:37 AM

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