Results 1 to 3 of 3
  1. #1
    KurtCGR
    Guest

    Huge number of calculations

    Access 2000 - I have a table that has nearly 2 million records in it. I need to read each record perform a custom complicated look up function that I wrote in VBA and then add the result to a column in the table. The routine usually explodes about 60% through the table. The errors lead me to believe that I have exceeded the maximum # of records lock settings. I have changed the number allowed (in VBA) to 1,000,000. Is there any down side to taking this number to 2,000,000 or even greater (I expect the number of records in this table to grow by several orders of magnitude). Is there some way to force the record locks to "flush"? I really don't need to lock the records. This routine only needs to be run once in a blue moon and it can be run "off line" with no multi-user worries. Everything else runs fine (if anyone wants to hear about 3 dimensional arrays of two dimensional rules let me know). Any help would be greatly appreciated.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    221
    Thanks
    0
    Thanked 20 Times in 19 Posts

    Re: Huge number of calculations

    If you don't need to enable multi-user access, make sure you open the database in Exclusive mode.

    Then you will not get any locks placed.

    Jeremy

  4. #3
    KurtCGR
    Guest

    Re: Huge number of calculations

    Jeez that was awful easy

    Thanks
    Kurt <img src=/S/salute.gif border=0 alt=salute width=15 height=20>

Posting Permissions

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