Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    File sharing lock count exceeded (Access 2002)

    I was running a thru a recordset updating a field in each record, I have 23765 records in the table however only 9494 records got updated before I get the attached error . I have tried exitting the database and trying again, still the error. I have even tried turning off the PC and trying again, still the error.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File sharing lock count exceeded (Access 2002)

    Hi Pat,

    Can this help : <A target="_blank" HREF="http://support.microsoft.com/default.aspx?scid=kb;en-us;815281">"File sharing lock count exceeded
    Francois

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: File sharing lock count exceeded (Access 2002)

    Thanks Francois, that article helped enormously. I used the following code to solve the problem:
    <pre> Set rs = dbs.OpenRecordset("tbl 7x7 Analysis Winners Ranked")
    rs.MoveLast
    DAO.DBEngine.SetOption dbMaxLocksPerFile, rs.RecordCount + 500
    </pre>


Posting Permissions

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