Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

DTS Import Access Database failure

Posted on 2006-07-20
3
Medium Priority
?
264 Views
Last Modified: 2013-11-30
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

0
Comment
Question by:Shezad Ahmed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 7

Accepted Solution

by:
FDzjuba earned 500 total points
ID: 17150186
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
 
LVL 4

Expert Comment

by:netfootprint
ID: 17184319
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
 

Author Comment

by:Shezad Ahmed
ID: 17231606
Thanks for your help.

I got The System Administrator to check the rights.

0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question