DTS Import Access Database failure

Hi All

I am trying to create a DTS package to import data from an Access Database.
The Access databse is located on the network.

When I choose the Access database to import I receive error "jet database engine. could not lock the file,"

The Access databse is not been accessed by any Users

I have tried both UNC and mapped drive.

The SQL Server service account is using the Domain administrator login. So is the SQL Agent.

I can write and delete from the network location of the Access database.

Any help highly appreciated.

Cheers
Shezad

Shezad AhmedAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
FDzjubaConnect With a Mentor Commented:
is the server has rights to WRITE to the directory on the net
Jet engine need to create LDB files in the directory in order to access the db.
0
 
netfootprintCommented:
This might seem like an obvious answer, but make sure you are using the latest MDAC. I have had issues where I appeared to have all the permissions I needed, but because of a mixed MDAC install, trying to import an earlier Access database into the new SQL Server resulted in the error you described.
0
 
Shezad AhmedAuthor Commented:
Thanks for your help.

I got The System Administrator to check the rights.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.