Post reply

Trying to connect to Access DB

  • September 19, 2005 at 12:44 pm

    #66698

    I clicked on the Access icon under Connection in DTS Package in Enterprise Manager. 

    A dialog box showed up entitled Conection Properties.  I seleted the file i wanted by browsing.  There is no username for the Access DB.  I put the password to open it.  I pressed ok and i got this message:

    "Error Source: Microsoft JET Database Engine

    Error Description: Cannot start your application. The workgroup information file is missing or opened exclusively by another user." 

    The access db is not opened and hasn't been opened for months.

  • September 19, 2005 at 1:00 pm

    #591090

    Is the database being protected by access user security?

    In this case you probably have to copy the mdw file to your sql server.

    A Workgroup Information File (*.MDW) stores information to authenticate a user. It stores the user names, group names, and passwords. It does not store any permission or rights to any database. Its main purpose is to verify that a user is really who they say they are. The permissions of the database objects, tables, queries, forms, etc., are stored in each MDB file. The System.mdw is the default workgroup filename created when you install MS Access.

  • September 19, 2005 at 1:36 pm

    #591118

    Sorry, you lost me. 🙂 

    All i want to do is tranfer my data from my Access DB into my SQL Server DB which i've created.  I don't want to manually put it there and I thought my book was explaining that but evidently it is not. So i need help.

    Thanks!

  • September 19, 2005 at 3:02 pm

    #591156

    1) adding an access database :

    EXEC sp_addlinkedsrvlogin

        @rmtsrvname = 'MyAccessTable',

        @useself = false,

        @locallogin = 'loginame',

        @rmtuser = 'admin', /*default access account*/

        @rmtpassword = NULL /*always NULL, see the link below*/

    2) The actual password doesn't seem to be an issue :

    http://support.microsoft.com/default.aspx?scid=285833

    I hope it works now.

    Once you have the linked server MyAccessTable set up , you can copy the tables via DTS.

  • September 20, 2005 at 12:52 pm

    #591469

    Have you tried copying the mdb file and saving to another name?

  • September 20, 2005 at 1:21 pm

    #591476

    I think it is the fact that the file is password protected. How do i get it off. I tried using the Access password but it is not satisfied. When i use a test DB the import/export wizard works fine.

  • September 20, 2005 at 1:32 pm

    #591478

    Ok, this problem is resolved. I hope that that will be the last one for this issue.

    Thanks guys. I got the password off that was the problem.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply