Post reply

dts job to pull data from an access database

  • April 3, 2003 at 8:17 am

    #151811

    I was looking to create a DTS job to pull data from an access database into a sqlserver database.

    I only want to retrieve data from the access mdb file for reads.

    When I choose the access database driver and the database file I want to pull the data from I get an error from the microsoft jet database “Could not lock file”. I don’t want to lock the file I just want to read it’s data. Is there some sort of setting I could use to not lock the file.

    Thanks

    David Weil

  • April 3, 2003 at 9:32 am

    #453057

    While you are running the DTS, do you have any other app accesing the mdb files?

    I think that it can't execute because the access files are in use.

  • April 3, 2003 at 2:54 pm

    #453103

    When you configure connection property to Access and you will see the advanceed option. Click it to open advanced option property and you will see property "Jet OLEDB : Database Locking Mode" and default value is "1". I can't find any information about this property and it may be the one you are looking for.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply