CreateWorkspace with Database Password RRS feed

  • Question

  • Hi All.


    I use DAO to create Query for Access 2003.

    but when i CreateWorkspace then error occur, my problem as bellow:


    DB : abc.mdb ; with Database Password = "12345" ( set in Access ) , User is "Admin"  Password = "".


          dao._DBEngine dbEng = new dao.DBEngineClass();

          dao.Workspace ws = dbEng.CreateWorkspace("", "admin", "", dao.WorkspaceTypeEnum.dbUseJet);


    This always return error :Can't start your application. The workgroup information file is missing or opened exclusively by another user.


    i try "dao.Workspace ws = dbEng.CreateWorkspace("", "admin", "110184", dao.WorkspaceTypeEnum.dbUseJet);"


    but it can not.

    Please help me, how i can connect my DB.


    Thanks so much.

    Sunday, July 4, 2010 8:23 AM