<div>
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. 
</div>


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.

<div>
Thanks for your help.<br />
<br />
I got The System Administrator to check the rights.<br />
<br />

</div>


Thanks for your help.

I got The System Administrator to check the rights.



<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
I am trying to create a DTS package to import data from an Access Database.<br />
The Access databse is located on the network.<br />
<br />
When I choose the Access database to import I receive error &quot;jet database engine. could not lock the file,&quot;<br />
<br />
The Access databse is not been accessed by any Users<br />
<br />
I have tried both UNC and mapped drive.<br />
<br />
The SQL Server service account is using the Domain administrator login. So is the SQL Agent.<br />
<br />
I can write and delete from the network location of the Access database.<br />
<br />
Any help highly appreciated.<br />
<br />
Cheers<br />
Shezad<br />
<br />

</div>
</div>


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



DTS Import Access Database failure

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.