SQL Server Performance

Error when creating an import using import tool

Discussion in 'SQL Server DTS-Related Questions' started by bouzahme, Apr 11, 2007.

  1. bouzahme New Member

    Hi,
    I want to import an MS Access database (secured) , using the import and export tool but I have the following error message "Unexpected error occurred. The provider has returned an error result without an error message".

    Note: When I remove the password from the MS Access DB, the import work properly.

    Thanks for your Help
  2. satya Moderator

    Yes it is due to the password on access database.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. bouzahme New Member

    Thanks a lot.

    Ahmed

Share This Page