Results 1 to 3 of 3

Thread: Import data from MS Access: URGENT issue please!

  1. #1
    Join Date
    Aug 2004
    Location
    USA
    Posts
    80

    Import data from MS Access: URGENT issue please!

    We have a production Access database and SQL Server database. When I created a DTS package to import data from Access and run manually, it works fine. But when I schedule, it doesn't work, saying some one already opened the file or no permission error.

    WE CAN'T get permissions for the Access file to the account that is assigned to SQL Server agent. It's internal policy of the company,because that account is used on all the sql servers to run the agent. Is there a work-around to import data from access. We do have a service account which has access to the Acess db.

    Thanks,

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Install SQL Client on another machine.

    Use Windows scheduler to schedule the DTS package. use the account which has access to the access database

  3. #3
    Join Date
    Aug 2004
    Location
    USA
    Posts
    80
    Excellent idea, that worked. Thanks!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •