locked
Moving a 2012 SQL server express server RRS feed

  • Question

  • Hi i am a student and i am creating a access front end with a SQL server backend. I can create this and use it happily on my laptop. But i am worried about how to move it to a removeable device to give to my lecturer at the end of the module so that they can review it. I am new to SQL server so please bare with me. If you require any more information please let me know.

    Thanks in advance

    Wednesday, June 27, 2012 2:32 PM

Answers

  • Hello,

    Backup or detach the database and copy it to the USB drive. Copy the MS Access front end to the USB drive.

    Create a written procedure with the following:

    1) How to restore/detach the database to an existent SQL Server instance on the lecturer computer. Explain how to create a login and assign proper permissions.

    2) Provide the following link to the lecturer with instructions on how to "Connect an existing Access project to a different SQL Server database". The lecturer should provide the name of the SQL Server instance,

    http://office.microsoft.com/en-us/access-help/create-an-access-project-HA010167953.aspx

    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Shulei Chen Monday, July 9, 2012 3:15 AM
    • Marked as answer by amber zhang Monday, July 9, 2012 4:01 AM
    Wednesday, June 27, 2012 5:40 PM