none
import data from access 2007 database to sql 2012 express

    Question

  • hi all,

    I'm trying to importing access 2007 database into sql epress 2012. i receive following error. please somebody help me to solve this.

    Thank you.

    TITLE: SQL Server Import and Export Wizard
    ------------------------------

    The operation could not be completed.

    ------------------------------
    ADDITIONAL INFORMATION:

    Cannot start your application. The workgroup information file is missing or opened exclusively by another user. (Microsoft JET Database Engine)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


    val_wick

    Wednesday, December 19, 2012 6:03 AM

Answers

  • The workgroup information file is missing or opened exclusively by another user.

    Hello,

    Seems there are user/security for the MS Access database file, which are store in the system.mdw file; see MSDN: The Workgroup Information File

    Is this file available/accessable? See the provided link how to add the target to the system.mdw in the connection string.


    Olaf Helper

    Blog Xing

    Wednesday, December 19, 2012 7:09 PM