Post reply

dtsrun works writing to Access 2000, but not Access 97

  • March 29, 2004 at 11:09 am

    #59249

    Hello,

    I was hoping someone could help me with a problem I am having.  I have upgraded a test machine to SQL 2000.  I have a dts package that writes to a MS Access 97 DB.  After the upgrade, the DTS package fails with the following message:

    ********************************************************************

    C:\Documents and Settings\nightlyprocess>dtsrun -Sservername -Uuser -Ppassword -NMyDTS

    DTSRun:  Loading...

    DTSRun:  Executing...

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_1

    DTSRun OnError:  DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005)

       Error string:  The Microsoft Jet database engine cannot open the file '\\MyPath

    \late.mdb'.  It is already opened exclusively by another user

    , or you need permission to view its data.

       Error source:  Microsoft JET Database Engine

       Help file:

       Help context:  5003051

    Error Detail Records:

    Error:  -2147467259 (80004005); Provider Error:  -534709256 (E020FBF8)

       Error string:  The Microsoft Jet database engine cannot open the file '\\MyPath\

    late.mdb'.  It is already opened exclusively by another user

    , or you need permission to view its data.

       Error source:  Microsoft JET Database Engine

       Help file:

       Help context:  5003051

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1

    DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)

       Error string:  The Microsoft Jet database engine cannot open the file '\\MyPath

    \late.mdb'.  It is already opened exclusively by another user

    , or you need permission to view its data.

       Error source:  Microsoft JET Database Engine

       Help file:

       Help context:  5003051

    Error Detail Records:

    Error:  -2147467259 (80004005); Provider Error:  -534709256 (E020FBF8)

       Error string:  The Microsoft Jet database engine cannot open the file '\\MyPath\

    late.mdb'.  It is already opened exclusively by another user

    , or you need permission to view its data.

       Error source:  Microsoft JET Database Engine

       Help file:

       Help context:  5003051

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_1

    DTSRun:  Package execution complete.

    ********************************************************************

     

    Here is what I have eliminated:

    1)  The user running the dts package has full access to the path specified.  This is not an access issue.

    2)  The file is not opened exclusively by another user.

    3)  I have another test machine on SQL 2000 that can run this package fine.  However, when I open the access 97 database, convert it to access 2000, the problem machine runs the dtsrun command without incident.

    4)  Both test machines have the same version of MDAC 2.7.

    5)  Both machines have the same version of MS Jet Engine - 4.0.6218.0

    So why does one machine work, but the other only works if I upgrade the access DB to Access 2000?

    It would be fairly tedious, as well as a testing nightmare, to upgrade all our access DB's to 2000.  I am hoping there is some other difference between the two machines that is an easy fix........but I can't find it.

    Thanks in advance for your help,

    AJR

  • March 29, 2004 at 7:20 pm

    #500995

    JET 4 was for 2000 and later 97 was I believe still Jet 3. Also did you install any Office or Access 97 pieces to the box taht is working?

  • March 30, 2004 at 8:15 am

    #501083

    Thank you for the response!  Even though I emphatically stated it was not an access issue, it turned out that it was.  The user I gave rights to was logged in and had the box locked, so it did not get the new access applied until we logged him off and then back on !!

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

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