dtsrun works writing to Access 2000, but not Access 97

Question

dtsrun works writing to Access 2000, but not Access 97

ajroney

SSC Eights!

Points: 833
More actions
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

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

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

Antares686 SSC Guru Points: 125444 More actions · Answer 1

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?

ajroney SSC Eights! Points: 833 More actions · Answer 2

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 !!