Error in Importing MS Access using DTS Import/Export


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Error in Importing MS Access using DTS Import/Export

  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Error in Importing MS Access using DTS Import/Export

    Hi ,
    I am trying to Import an Access Database using the DTS Import/Export Wizard
    The Access Database is password protected, I am using the username and password to access it.
    Based on one of the other threads in this forum, I copied the system.mdw file to winnt/system32 and specified the pathname in the advanced tab, as I was getting a missing Workgroupfile error.

    I am getting the following error when trying to connect.

    The Microsoft Jet Database Engine cannot open the file. It is already opened exclusively by another user, or you need permission to view its data.

    Any help is appreciated.

  2. #2
    Join Date
    Mar 2005
    Location
    Los Angeles, Calif. AKA: Gangsta Yoda™
    Posts
    455
    Sometimes there is a issue when you open a db exclusively and close it that it retains the exclusive access. You just need to open it regularly in Explorer to make it shared.

    Also, you dont need to have the system.mdw in the system32 directory. Make sure you have permissions to access it. If you want to be sure, just move the system.mdw to a publically accessible folder and pass wht system.mdw in your open connectionstring parameters.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer code questions via PMs.
    Microsoft MVP 2006-2009
    Office Development FAQ (VBA, VB6, VB.NET, C#)
    Software Engineer MCP (VB6 & .NET)
    Reps & Rating PostsVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6Outlook Global Address List

Similar Threads

  1. Problem when inserting values to different columns
    By outcast1881 in forum Database
    Replies: 1
    Last Post: 08-23-2006, 11:51 AM
  2. SQL Help....still importing cvs text file into access
    By chupacabra in forum VB Classic
    Replies: 1
    Last Post: 07-31-2006, 09:54 AM
  3. Replies: 60
    Last Post: 09-13-2002, 05:41 PM
  4. Replies: 0
    Last Post: 11-20-2000, 05:32 AM
  5. Replies: 0
    Last Post: 04-11-2000, 12:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center