Post reply

DTS connection to Password Protected Access DB

  • December 5, 2003 at 7:43 am

    #160208

    I have an Access DB from which I need to DTS records to SQL Server. I have been removing the password from Access every time I need to DTS because I don't know how to connect with it in place. DTS returns the error message that the workgroup file is missing. I went to Access and created a workgroup file which put an mdw file on my HD. Still got the same error message. Help?

    Jules

    [font="Courier New"]ZenDada[/font]

  • December 5, 2003 at 8:27 am

    #484844

    FROM BOL:

    quote:

    To access a secured Access database, configure the registry (using the Registry Editor) to use the correct Workgroup Information file used by Access. Use the Registry Editor to add the full path name of the Workgroup Information file used by Access to this registry entry:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\SystemDB


    * Noel

Viewing 2 posts - 1 through 1 (of 1 total)

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