Microsoft ace 12.0 - Not able to pass 2 query at the same time RRS feed

  • Question

  • Hi,

    I had a linked server provider by Microsoft Ace 12.0 to read dbf files.  I made a agent job to update sql from dbf files and all run perfectly.  The matter is when I execute an another query during the execution time of the job, my new query don't execute immedialely.  I must wait until the job was completed.

    Thank for help

    Monday, November 10, 2014 2:04 PM


  • I don't believe that multi-user capability is supported by the dBase ISAM since it will place an exclusive lock on the database.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Proposed as answer by Fred Bao Tuesday, November 11, 2014 3:47 AM
    • Marked as answer by Fred Bao Friday, November 21, 2014 7:45 AM
    Monday, November 10, 2014 7:48 PM