Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Unanswered: Table lock when importing data from Ms Access to SQL Server 2k

    hi,

    am trying to schedule a regular copy of an MS Access table into an SQL Server database using the DTS import. Now that Access table is constantly updated by another software. So when the package is run as a scheduled Job, it fails on an error that the Source table is exclusively locked by another user and so the data cannot be obtained.

    All I need is a read-only access to the access database/table to copy the data into mine.

    But where do i set the value for read-only, nolock access while configuring the DTS package?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You don't...it's an access thing...sounds like you have the application layer and data layer in access as 1.

    sepearte the 2 so the application layers is linked to the data layer....

    THEN...read the tables...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Oct 2003
    Posts
    5
    but the Access DB is a third party application that am trying to access. is there some way which i can just read the data and not lock it?

    Originally posted by Brett Kaiser
    You don't...it's an access thing...sounds like you have the application layer and data layer in access as 1.

    sepearte the 2 so the application layers is linked to the data layer....

    THEN...read the tables...

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You're not locking it, Access is...

    What's the configuration of the Access app?

    Is the applcaition layer separate from the data?

    Or is it a client onl;y package? Is it a single install?

    Just make sure no one is logged on to it.

    Also, is ther access security enabled?

    If there is, do you know how to add the security to the dts pacjage (look in advanced)
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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